[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 248
  • Last Modified:

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.
 
0
gelbert
Asked:
gelbert
  • 2
  • 2
1 Solution
 
Amritpal SinghCommented:
i think this should help

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

have a look
0
 
gelbertAuthor Commented:
       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
0
 
Amritpal SinghCommented:
hi
the following link discusses about excel 11.0
have a look

http://support.microsoft.com/kb/308407/EN-US/

i hope it'll help
0
 
gelbertAuthor Commented:
Thanks
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now