How to disable "AutoIt Error" msgbox?

[SeF]

Hi there!

I'm using a script that keeps executing some Excel commands every minute in an Excel Sheet and some rare cases appears that message “The requested action with this object has failed.” (Without even touching the computer).

I guess that is a AutoIt + COM Object attachment issue, because it happens too while doing simple stuffs like reading/writing stuffs in the Cells and I don't If is possible to resolve it. Any comments?

So, my solution is:

Create another script that keep checking if my 'main script' is still running, If not, run it again.

For that, I need to disable the "AutoIt Error" messagebox that appears when happens this error.

Sorry If I couldn't explain properly my issue

Thanks!

[l3ill]

you can disable the msgbox by placing a semicolon( ; ) in front of it.

or you can post the code you are working with so we can see if there are any other strangenesses.

[KaFu]

I'm not that good with COM+, but I think implementing a custom COM Error Handler to gracefully catch the errors (write them to console instead?) would be the best approach. See an example of that in the help-file for function ObjEvent().

[UEZ]

Try to use

Global $oError = ObjEvent("AutoIt.Error", "_ErrFunc")
...
<your code>
...
Func _ErrFunc()
;~  ConsoleWrite($oError.scriptline & ";" & $oError.source & ";" & $oError.description & @CRLF)
    Return
EndFunc

It should bypass the em.

BR,

UEZ