So I open a workbook with macros, and then another workbook with data,
and run A_macro... as follows...
require Win32::OLE;
require Win32::OLE::Const;
Win32::OLE::Const->Load('Microsoft Excel');
$Win32::OLE::Warn = 3;
$Win32::OLE::Warn = 3;
my $Excel = Win32::OLE->new('Excel.Application', 'Quit');
my $gl = $Excel->Workbooks->Open(
$ENV{'APPDATA'} . "\\Microsoft\\Excel\\XLSTART\\gl.xls");
my $Book = $Excel->Workbooks->Open("SomeData.xls");
$Excel->Run("gl.xls!A_macro");
$Book->Close( 0 );
$gl->Close( 0 );
$Excel->Close;
I get an error on the last line:
Win32::OLE(0.1707) error 0x80020011: "Does not support a collection"
in METHOD/PROPERTYGET "" at d:\my\perl\src\roster_data.pl line 3352
Any clues as to what this message means, in this context? And how I can
cure it?
--
Glenn -- http://nevcal.com/
===========================
A protocol is complete when there is nothing left to remove.
-- Stuart Cheshire, Apple Computer, regarding Zero Configuration Networking
_______________________________________________
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
