Re^5: Win32::OLE called by subroutine only workes once

in reply to Re^4: Win32::OLE called by subroutine only workes once
in thread Win32::OLE called by subroutine only workes once

I'm writing a script which opens each excel file in a directory, reads some values from the workbook, then closes the workbook, and I had the same problem of Excel quitting when I closed the workbook.

The inspiration came when I noticed the problem did not happen if I manually opened Excel first (with the default, blank "Book1")

The work-around I used was to create a new workbook first, process all the files, (open, close, open, close...) then close my "KeepOpen" workbook when I was all done:

$KeepOpen = $Excel->Workbooks -> Add;
# your code / loop here
$KeepOpen -> Close;
[download]

Hope this helps,
-- zaaj

Comment on Re^5: Win32::OLE called by subroutine only workes once Download Code

Replies are listed 'Best First'.
Re^6: Win32::OLE called by subroutine only workes once by Anonymous Monk on Dec 23, 2016 at 21:13 UTC
Thank you very much, this worked for me!	[reply]

In Section Seekers of Perl Wisdom