in reply to Re^4: Capturing excel macro errors
in thread Capturing excel macro errors

jrsimmon:

Okay, then. Three final useless suggestions before I go to bed. ;^)

1) How about have a (generous) timeout on the operation and assume it failed if you reach it? (Course, then you'd have to kill the job, and "graceful shutdown" is no longer on the menu.)

2) Assuming the problem is a dialog box hanging you up, maybe a perl program that would "notice" new windows on the server and nudge your script if it happens to belong to Excel?

3) Go all out and hook into the debugger hooks (the ones that ask you if you want to debug the application yadda yadda), make a perl module that handles it, post it on CPAN, and reap the glory? ;^D

(I was originally going to give you a different three suggestions. The third one was "Profit", but I couldn't figure out the second one.....)

...roboticus

Replies are listed 'Best First'.
Re^6: Capturing excel macro errors
by jrsimmon (Hermit) on Dec 03, 2007 at 03:24 UTC
    I'm working on #1 currently. I like #2...that helps...now I only have to figure out how to do it...I'll get back to you on #3 when I have a bit more perl experience! Thanks for your help.