Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

On Error

Status
Not open for further replies.
On Error Resume Next and On Error Goto 0 are your only choices.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]
 
Thank w33mhz
But will something like this do?

Code:
If Err.Number <> 0 Then
    WriteEventE("Error Message String")
End If
On Error GoTo 0

(Please note, I've not tested nor sanity checked this code snippet at all!)

JJ
[small][purple]Variables won't. Constants aren't[/purple][/small]
 
That is pretty much the standard way to handle errors.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top