pebcak
09-15-2021, 06:28 AM
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!
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!