Re: Win32::OLE formatting Excel Worksheet

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!

Comment on Re: Win32::OLE formatting Excel Worksheet

Replies are listed 'Best First'.
Re^2: Win32::OLE formatting Excel Worksheet by Nkuvu (Priest) on May 10, 2004 at 17:04 UTC
Another tool I've used extensively is the object browser from within Excel itself. Press Alt-F11 to get to the VB editor, then F2 to get to the browser itself.	[reply]
Re: Re: Win32::OLE formatting Excel Worksheet by Anonymous Monk on May 11, 2004 at 06:13 UTC
Thanks all for the information. I do not find OLE browser, however, I am getting hands on the use of Excel's Object Browser for those method/property access. $Book2->Styles("Normal")->{Font}->{Name} = "Arial"; Thanks again for example and info.	[reply]
Re: Re: Re: Win32::OLE formatting Excel Worksheet by guha (Priest) on May 11, 2004 at 07:34 UTC
On my box I can invoke the OLE Browser either via Start-Program-ActiveState-Ole Browser or by clicking the link in the TOC of the html-docs. The link is in fact `file:///C:/Perl/html/OLE-Browser/Browser.html` [download] but I don't know how that maps to your setup.	[reply] [d/l]
Re: Re: Re: Re: Win32::OLE formatting Excel Worksheet by Anonymous Monk on May 12, 2004 at 16:12 UTC
Found that browser in my box. Thanks. Tommy	[reply]