Link to home
Start Free TrialLog in
Avatar of gelbert
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.
 
Avatar of Amritpal Singh
Amritpal Singh
Flag of India image

i think this should help

http://support.microsoft.com/kb/q178782/

have a look
Avatar of gelbert
gelbert

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
ASKER CERTIFIED SOLUTION
Avatar of Amritpal Singh
Amritpal Singh
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gelbert

ASKER

Thanks