in reply to Perl Excel OLE help
You could use a loop like this to set the $Sheet object equal to the Position worksheet:
chinman
for (1..$Book->Worksheets->Count) { my $name = $Book->Worksheets($_)->{Name}; if ($name =~ /Position/) {$Sheet = $workbook->Worksheets($_)}; }
chinman