in reply to Perl Excel OLE help

"Invalid index" in METHOD/PROPERTYGET "Worksheets" seems to indicate 1) your worksheets don't have names or 2) your version of Worksheets method doesn't support names

Excel Object Model Overview Excel 2007 Developer Reference How to: Refer to Sheets by Name - Excel 2007 Developer Reference

Replies are listed 'Best First'.
Re^2: Perl Excel OLE help
by mmittiga17 (Scribe) on Jan 07, 2010 at 00:04 UTC

    When I try to record a macro I get this: Sheets("Position").Select Which shows a Tab called Position. Also, the below code returns worksheet names and one of them is Position.

    for (1..$Book->Worksheets->Count) { print "$_: <", $Book->Worksheets($_)->Name, ">\n"; }
    I do not get it.