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

in reply to Win32::OLE called by subroutine only workes once

I don't know, but would guess that M$ have implemented the close call to return immediately after the close has been issued downward i.e. not waiting for completion of the closure.

Try putting a sleep between the calls ... a near equivalent of running the code in the debugger when the delay would be mandraulic ;-|

Just a thought...

A user level that continues to overstate my experience :-))

Comment on Re: Win32::OLE called by subroutine only workes once

Replies are listed 'Best First'.
Re^2: Win32::OLE called by subroutine only workes once by fish (Novice) on Aug 11, 2009 at 13:21 UTC
Thanks for your ideas. `$book->Close(1);` instead of `$book->Close();` seems to work - but please do not ask me why :D Regards, fish	[reply] [d/l] [select]
Re^3: Win32::OLE called by subroutine only workes once by fish (Novice) on Aug 14, 2009 at 06:59 UTC
Ok, obviously it was just fortune that it worked with close(1). Today I want to use the script again and it fails saying: Win32::OLE(0.1709) error 0x80010108: "Das aufgerufene Objekt wurde von den Clients getrennt" Does anybody has an idea how I can solve this problem?	[reply]
Re^4: Win32::OLE called by subroutine only workes once by ganeshabelavadi (Novice) on May 13, 2011 at 11:16 UTC
Hi, Even I'm facing same issue The error says "Win32::OLE(0.1709) error 0x80010108: "The object invoked has disconnected from its clients"" I'm calling the function twice which is having excel opening and closing commands. Please help how can I solve this issue?	[reply]
Re^5: Win32::OLE called by subroutine only workes once by nll (Initiate) on Nov 29, 2012 at 15:27 UTC
Re^5: Win32::OLE called by subroutine only workes once by Anonymous Monk on Mar 01, 2012 at 17:35 UTC
Re^6: Win32::OLE called by subroutine only workes once by Anonymous Monk on Dec 23, 2016 at 21:13 UTC
Re^4: Win32::OLE called by subroutine only workes once by Anonymous Monk on Jan 26, 2012 at 09:07 UTC
Hello, did you solve this problem? I have the same problem at the moment. My script runs some weeks very fine. But since three days I have this problem. First I get this error only if I try to open the second excel file, now I get it at the first call, too. Thanks in advanced. Tim	[reply]
Re^4: Win32::OLE called by subroutine only workes once by Anonymous Monk on Jan 26, 2012 at 09:08 UTC
Hello, did you solve this problem? I have the same problem at the moment. My script runs some weeks very fine. But since three days I have this problem. First I get this error only if I try to open the second excel file, now I get it at the first call, too. Thanks in advanced. Tim	[reply]

In Section Seekers of Perl Wisdom