Opening an Excel workbook with links to other data sources

[Suresh Govindachar]

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
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs