in reply to Open an excel file using win32::ole module
Make this change and test your example again:
my $Excel = Win32::OLE->new( 'Excel.Application', 'Quit' );
becomes:
my $Excel = Win32::OLE->new('Excel.Application');
Or if you want to check for and use any existing Excel instances:
my $Excel = Win32::OLE->GetActiveObject('Excel.Application') || Win32::OLE->new('Excel.Application');
|
|---|