Re: Using Win32::OLE and Excel - Tips and Tricks

[Anonymous Monk]

I needed to open a spreadsheet with links to external files, which or may not be open. The following snippet did the trick:

my $Book = $Excel->Workbooks->Open("$EXCELFILE", TRUE);