Excel - Outlook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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")
 
Back
Top