Huub,

Thanks for that info. I think I downloaded the trial version of the PDK a while back, but didn't think I could justify the purchase. I'll try it again for this -- maybe I'll change my mind about buying it!

Thanks,

Phil

----- Original Message ----- From: "Huub Peters" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[email protected]>
Sent: Thursday, December 15, 2005 4:56 AM
Subject: Re: Re:Working example of code that runs as EXCEL macro/module


I want to run perl code as a function/module inside EXCEL, in the same
way that one can run VBA.

Despite of other reports that say it can't be done I think it can.
There is a tool called PerlCtrl which is part of the ActiveState
Perl Development Kit that can do just that.
At least it provides an example of a PerlCtrl that encapsulates part of
Perl's
regular expressions so they can be used from within MS Word.
If it can do that I'm pretty sure it can be used from Excel also.

I've never used it, just ran the example once and it worked.
The PDK is not free but I've been using it for years now and I think
it is well worth it's money. You can download a free 21-day trial from
the AS website.

Regards,

Huub Peters



_______________________________________________
Perl-Win32-Users mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Reply via email to