If you plan to use Win32::OLE to interact with Microsoft applications often - I have found ActiveState's VBScriptConverter which ships with their PDK Productivity Tools to be very helpful. This program will convert VB Macros directly to Perl code.

Another useful tip: After recording a Macro in Excel - press Alt+F11. This will open up Visual Basic where you will be able to view and edit the VBScript generated when you recorded the Macro. You can then convert this to perl yourself using the rules in the Win32::OLE documentation - or paste it into the VBScriptConverter and let it do the work.

From within Visual Basic - you can also press F2 (or select View->Object Browser) to bring up the object browser. Here you can view the different attributes and methods of the different objects you can interact with.

I find that when you are unsure of how to do something, this is the easiest way to figure it out is to record the Macro and then look at the VBScript that was generated. This is usually much easier and quicker than piling through documentation.