What do you want this macro to do?
You can create an instance of the COM object that Exposes Excel to VB
(and any other language that understands COM -- like perl)..
---------------
use Win32::OLE;
$excel= Win32::OLE->new("Excel.Application");
But that's not code running like an Excel macro...
As far as I know, you can't run Perl code inside of Excel in VBA unless
it would take a VBS file or would understand a script language tag...
Like so (to direct it to the correct interpreter)..
<SCRIPT LANGUAGE="PerlScript">
...whatever
</SCRIPT>
And again, I don't think this is possible. I've looked at doing
something similar inside of Outlook and couldn't make it work -- and was
forced to write VB.
Steven
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Suresh Govindachar
Sent: Wednesday, December 14, 2005 3:50 PM
To: [EMAIL PROTECTED]; [email protected]
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 your need, viz:
"[you] want to run perl code as a function/module
inside EXCEL, in the same way that one can run VBA."
As far as I know, this cannot be done (since excel does
not come with perl embedded in it; and one can't
embed perl into excel without having the source for
excel).
--Suresh
urls provided by VnPenguin were:
> http://www.adp-gmbh.ch/perl/excel.html
> http://homepage.eircom.net/~jmcnamara/perl/PerlExcelFaq.html
> http://blazonry.com/perl/xl_oleauto.php
> --http://vnoss.org Vietnamese Open Source Software Community
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, December 14, 2005 12:53 PM
To: [email protected]
Subject: Re:Working example of code that runs as EXCEL macro/module
The URL you provided does not work.
I was able to find some stuff under "jcmcnamara" in the URL where perl
is being used to 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 code that runs as EXCEL macro/module
> To: win32-users list <[email protected]>
> Message-ID:
> <[EMAIL PROTECTED]>
> Content-Type: text/plain; charset=UTF-8
>
> 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 works.
> Google is your friend:
> http://www.adp-gmbh.ch/perl/excel.htmlhttp://homepage.eircom.net/~jmcn
> amara/perl/PerlExcelFaq.htmlhttp://blazonry.com/perl/xl_oleauto.php
>
> --http://vnoss.orgVietnamese Open Source Software Community
>
>
> ------------------------------
_______________________________________________
Perl-Win32-Users mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
_______________________________________________
Perl-Win32-Users mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
_______________________________________________
Perl-Win32-Users mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
