While writing an email in Outlook, I want to run a script that will read the value of a cell in an Excel file that may or may not be open. (There's more to it than that, but I'll be able to figure the rest out once I figure out how to get Outlook to read the Excel sheet).

But I can't even get Outlook to create an instance of Excel...


Dim excelApp as Object
set ExcelApp = createobject("Excel.Application")
gives me errors.

Can someone get me started on reading the value of cell D4 in c:\myfile.xls from Outlook without having to open the Excel file?

I would be very grateful!! THANK YOU!