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

[Reverend Phil]

++ wonderful tutorial. I've been using much of this functionality for some time, but I can slick a few snips from you to clean up a few lines here and there. And thanks for pointing out the DisplayAlerts property. Man, there's a great deal of hubbub in that object. =)

-=rev-=

[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);