Would something like the following work?
my $Sheet = $Book->Worksheets(3);
$Sheet->Activate;
$Excel->Run('mySpreadsheet.xls!Sheet1.vb');
Just specify the name of the wookbook (Sheet1 in this example) you want the
script to run from. I think it should run on the active sheet.
AG
> -----Original Message-----
> From: Hon Shi [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 09, 2005 1:17 PM
> To: [email protected]
> Subject: xcel, run a macro?
>
>
> I've got the target sheet open and happy.
> Is there anyway to fire off a macro from perl?.. given:
>
> The macro (in "vb") is
> 1. in another workbook
> 2. in the present workbook.
>
> Thanks
>
>
>
>
>
>
>
> ______________________________________________________
> Click here to donate to the Hurricane Katrina relief effort.
> http://store.yahoo.com/redcross-donate3/
> _______________________________________________
> 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
