How to open Excel file from PowerPoint?
I think you have to load them all manually when using automation, so you
need to open them as any other Excel file.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Bob H" wrote in message
...
Office XP
From a macro in PowerPoint, I open an Excel file I want to work with. I
use:
Excel.Workbooks.Open FileName:= _
"C:\Whatever.xls"
Excel.Application.Visible = True
Excel and the file open, but I don't have access to my Excel addins. Their
commands no longer appear in the Tools menu. (For example, Bovey's
CodeCleaner.) However, the addins show as installed and loaded.
How can I open the Excel file from PowerPoint with addins intact?
Is there anything else I should know about opening Excel from PowerPoint?
Thank you.
|