in reply to Using Win32::OLE and Excel - Tips and Tricks

++ 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-=
  • Comment on Re: Using Win32::OLE and Excel - Tips and Tricks

Replies are listed 'Best First'.
Re: Using Win32::OLE and Excel - Tips and Tricks
by Anonymous Monk on Dec 18, 2002 at 19:22 UTC
    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);