Open Excel.. choose tools..macros... visual basic editor..then click the object browser icon in the toolbar... its a box with 3 things coming out of it.
Then you see the object browser. On the left you see the classes. On the right you see the methods. to receive help on a selected method you have to hit the question mark on the object browser window with the method or class selected.
just a note.. with ole you reference methods and properties like so

my $excel  = Win32::OLE->new("Excel.Application");
$excel->{someproperty}
$excel->somemethod();
[download]

For collections of objects such as worksheets, you can either use

$excel->collection($someindex) ;
||
$excel->collection->Item($someindex);
[download]

to reference specific items in the collection. Hope this helps.