Excel - Outlook

D

DMc2004

How can i load an excel spreadsheet when i am in Outlook, at present i have a
procedure that runs and want to transfer some information from an email and
userform straight into Excel.

David
 
M

Michael Bauer

Hi David,

sample:

Dim oWb as Excel.Workbook
Dim oXl as Excel.Application
Set oXl=New Excel.Application
Set oWb=oXl.Workbooks.Open("c:\file.xls")
 
Top