Re: Win32::OLE, Excel, and process control

It seems inelegant to put a hardcoded delay into the program. How do I get this thing to pace itself?

You show an error message output from line 130 -- although there doesn't seem to be any error handling there? -- so, it ought to be possible for your program to detect that error -- perhaps with eval block or one of the try/catch modules; -- and when you detect an error, back off for a couple of seconds and then retry it.

With the rise and rise of 'Social' network sites: 'Computers are making people easier to use everyday'

Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.

"Science is about questioning the status quo. Questioning authority". I knew I was on the right track :)

In the absence of evidence, opinion is indistinguishable from prejudice. Not understood.

Comment on Re: Win32::OLE, Excel, and process control

Replies are listed 'Best First'.
Re^2: Win32::OLE, Excel, and process control by marinersk (Priest) on Jun 10, 2016 at 03:04 UTC
As always, with retry logic, it is unlikely that you want your program to hang in the event the problem is a permanent one. I'd advise a retry counter, and a threshold at which point you abort on the file.	[reply]
Re^2: Win32::OLE, Excel, and process control by mcoblentz (Scribe) on Jun 08, 2016 at 22:55 UTC
I'll give it a shot, thanks.	[reply]