From the discussion "Win32::OLE to write macro to Excel workbook?",
something called PerlCOM might help to replace VB script
http://opensource.activestate.com/authors/jandubois/Perl/TPC3/fun.html#Using_PerlCOM_Babelfish_for_Mic
--Suresh
___
P
TED]>
To: "Suresh Govindachar" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>;
Sent: Wednesday, December 14, 2005 9:55 PM
Subject: RE: Working example of code that runs as EXCEL macro/module
What do you want this macro to do?
You can create an instance of the COM object that Expo
l-win32-users@listserv.ActiveState.com
Subject: RE: Working example of code that runs as EXCEL macro/module
If one examines the url provided (rather
than just going clickty-click with the mouse),
one can see how to get to their sites (see PS below).
However, those sites won't answer yo
o create an excel file. This is not what I
want to do. I want to run perl code as a function/module inside EXCEL, in the
same way that one can run VBA.
Thanks,
Phil
> Date: Tue, 13 Dec 2005 23:47:35 +0100
> From: VnPenguin <[EMAIL PROTECTED]>
> Subject: Re: Working example of co
On 12/13/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:> Can someone post or
point me to some working code that runs under EXCEL?> Doesn't have to be
anything fancy, in fact, simpler is probably better. I> just want a starting
point that illustrates how the interface between EXCEL> and perl wo