gelbert
asked on
How to read titles of sheets in Excel file?
Hi!
I have Excel ".mht" (Excel Template file). I need to retrieve names of sheets in that file. I would appreciate any advice.
I have Excel ".mht" (Excel Template file). I need to retrieve names of sheets in that file. I would appreciate any advice.
ASKER
Thanks for your advise. Link is very helpful. But I am working agains MS Office 11 and as far as I can see: Application object does not have function GetWorkbooks(). It only has function Workbooks(VARIANT vtParam) which takes parameter , but I have no idea what to pass into function. Any suggestions?
File with interface descriptions which is generated for MS Office 11 is called xl5en32.h
File with interface descriptions which is generated for MS Office 11 is called xl5en32.h
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
http://support.microsoft.com/kb/q178782/
have a look