> -----Original Message-----
> From: Edward G. Orton [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 20, 2002 2:03 PM
> To: [EMAIL PROTECTED];
> [EMAIL PROTECTED]
> Subject: Re: Perl, OLE, and Excel commands.
>
>
> ----- Original Message -----
> From: "Daniel Needles" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, February 20, 2002 4:54 PM
> Subject: Perl, OLE, and Excel commands.
>
>
> > Hello,
> > I've been playing around with spawning and populating Excel
> > spreadsheets from PERL scripts.
> >
> > There are a number of modifications I would like to make to
> the sheets
> > from PERL (i.e Format->Columns->Auto Width.) However, I have
> not found
> > a good reference to potential Excel commands available via OLE
> and
> > their syntax. Is there either a reference or a general way to
> call
> > Excel Menu commands from OLE from within PERL?
> Try looking at the VB reference help file within Excel. The
> Objects and Methods for VB are defined there, and you can call
> them from a perl script by changing the VB '.' notation to
> Perl's '->' notation. It's a good place to start.
Depending on the installation method, these may or may not be available on
your system. If they are not, and you have access to the installation
media, you can add them using the same setup program used to install MS
Office. Alternatively, you can use the OLE Object Browser, accessible from
within Excel. From Excel, select Tools | Macro | Visual Basic Editor, then
within VBE, select View | Object Browser (or just click on the Object
Browser button in the toolbar).
The VBA Reference Manual is also accessible off Microsoft's MSDN site.
HTH,
Ian
_______________________________________________
Perl-Win32-Users mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
