Excel - Outlook

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to transfer the data from userform to spreadsheet for specific dates 0
Excel Excel 2007 fails on insert userform 0
Using Excel UserForm from Open Workbook in Outlook VBA 5
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Use Excels Analysis ToolPak in Outlook 0
"Cannot load GUI library into memory" 3
Select contacts and paste in Excel 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2

Top