-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
