more useful options | |
PerlMonks |
Re: Win32::OLE formatting Excel Worksheetby guha (Priest) |
on May 10, 2004 at 15:24 UTC ( [id://352107]=note: print w/replies, xml ) | Need Help?? |
There are two utilities that are invaluable when using Win32::OLE.
1. The macro recording facility in Excel/Word/insert the OLE engine of your choice. It is pretty straightforward to translate VBA to Perl. 2. Our own brother jand's OLE browser which is included at least in the ActiveState distribution. This utility can't be praised enough. As for your question I think it will be an nice exercise to answer it yourself using the two tools above. Welcome back if all else fails!
In Section
Seekers of Perl Wisdom
|
|