> Lynn. Rickards Sent: Wednesday, April 19, 2006 6:02 PM > >Suresh Govindachar wrote: >> Hello, >> >> Issue: opening an excel file brings up a dialog box >> stating that the "workbook contains links to >> other data sources" and asks if the data >> should be updated. >[...] >> 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; >[...] > > my $Book = $Excel->Workbooks->Open($file, {'UpdateLinks' => 3}); > > The value 3 I got from some VB code someplace I forget, and > have no clue what it means - hunted on MSDN to no avail. > Anyone?
From the documentation for the open method: -------8<------- Opens a workbook. expression.Open(FileName, UpdateLinks, ReadOnly, Format, Password, WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter, Editable, Notify, Converter, AddToMru, Local, CorruptLoad) expression Required. An expression that returns the Workbooks object. FileName Required String. The file name of the workbook to be opened. UpdateLinks Optional Variant. Specifies the way links in the file are updated. If this argument is omitted, the user is prompted to specify how links will be updated. Otherwise, this argument is one of the values listed in the following table. Value | Meaning ------+------------------------------------------------------- 0 | Doesn't update any references 1 | Updates external references but not remote references 2 | Updates remote references but not external references 3 | Updates both remote and external references If Microsoft Excel is opening a file in the WKS, WK1, or WK3 format and the UpdateLinks argument is 2, Microsoft Excel generates charts from the graphs attached to the file. If the argument is 0, no charts are created. -------8<------- > > BTW Options to book->Open are fully listed in the Object Browser. > --Suresh _______________________________________________ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs