Setting behaviour upon error - Answered

[shornw]

This may be really simple or not possible, I really don't know.

I have a script which opens several Excel workbooks and does various things. To prevent the operator clicking in the sheet, which causes the script to fail, I open the sheets using the 0 (hidden) option. Occasionally I get an unexpected error (I know - they shouldn't happen, but occasionally they do..! please note: this isn't what I'm interested in resolving at the moment, the script has error handling for appropriate parts) which leaves the workbooks open.

My question is, is it possible to have an over-arching error control, so that in the event of an 'unexpected' error occurring, then any open workbooks would be closed - kind of like when HotKeys are set, so that whatever the script is doing a function is called.

Is this possible, am I talking nonsense or is this such a simple thing to implement that I should hang my head in shame

As always, thanks for any ideas

Edited May 30, 2012 by shornw

[JohnOne]

http://autoitscript.com/forum/topic/126714-onautoiterrorregister-handle-autoit-critical-errors/

Perhaps.

[shornw]

Excellent and thank you. This looks to be exactly what I wanted