How to read titles of sheets in Excel file?

Posted on 2004-11-05
Last Modified: 2013-11-20
   I have Excel ".mht" (Excel Template file). I need to retrieve names of sheets in that file. I would appreciate any advice.
Question by:gelbert
    LVL 6

    Expert Comment

    by:Amritpal Singh
    i think this should help

    have a look
    LVL 8

    Author Comment

           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
    LVL 6

    Accepted Solution

    the following link discusses about excel 11.0
    have a look

    i hope it'll help
    LVL 8

    Author Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Suggested Solutions

    Title # Comments Views Activity
    Powershell based monitoring system 2 118
    Tab names are off by one 5 48
    sum67 challenge 35 76
    has77  challenge 9 56
    Introduction: Dialogs (1) modal - maintaining the database. Continuing from the ninth article about sudoku.   You might have heard of modal and modeless dialogs.  Here with this Sudoku application will we use one of each type: a modal dialog …
    Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
    This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now