Excel - work*** indices?

From: Ripley (ripley_at_ihatespam.com)
Date: 02/23/05

  • Next message: Gérard Leclercq: "Re: Copy between identical tables" 
    Date: Wed, 23 Feb 2005 08:40:25 -0800

    I know how to construct a query for a named work***, but what if I don't
    know the name of the work***, or even how many? I'd like to do something
    like this:

    For i=0 to number of worksheets
        query work***[i]

    So I need to know if (a) I can programmaticaly determine the number of
    worksheets via ADO and (b) access each worksheet by its index, and not its
    name (OR somehow determine the name, if part (a) is possible)

    This application is being written in C#, using ADO to access the Excel
    workbook.

    Thanks,
    Ripley
     

  • Next message: Gérard Leclercq: "Re: Copy between identical tables"