Hello,
When I manually open an Excel file, it bring up a dialog box
stating that the "workbook contains links to other data sources"
and asking if the data should be updated. The following perl code
brings up a similar dialog box:
use Win32::OLE qw(in with);
use Win32::OLE::Const 'Microsoft Excel';
my $Excel = Win32::OLE->GetActiveObject('Excel.Application') ||
Win32::OLE->new('Excel.Application', 'Quit');
my $Book = $Excel->Workbooks->Open($file); # open Excel file
my $Sheet = $Book->Worksheets(1); # select worksheet number 1
$Book->Close;
How do I answer "No" from within the perl code?
Thanks,
--Suresh
_______________________________________________
Perl-Win32-Users mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
