Re: Newbie: Accessing an Excel worksheet from a Collection

On 7/29/04 11:46 AM, "Keith McAlpine" <[email protected]> wrote:

> mySheet = (DispatchPtr) sheets.invoke("Item", 1);

I don't work with Excel but a quick check at MSDN does not indicate an Item
method but instead a Select method.  So the proper call would be:

    DispatchPtr mySheet = (DispatchPtr) sheets.invoke("Select", 1);
or
    DispatchPtr mySheet = (DispatchPtr) sheets.invoke("Select", "sheet1");

hth,

Steven
---

/**
 * Systems Integrator
 * Interactive Tecnologia, Lda.
 * Lisbon    Portugal
 *
 * tel: +351 21 440 8090
 * fax: +351 21 441 7242
 * sip:[email protected]
 */