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