David,
I am giving you 2 links instead of one, the first one I gave you below is
the best one and the description of the On Error is also shown below.
After reading Aaron's response I looked it up and on error goto 0 in the
old days haulted the program but now it just clears "ALL" error handling you
have in the program, so it says.
So below I added both links for you or anyone who wants it.
Bruce
David,
Ignore the last link I gave you MSN took it to it's page.
Use this one below,
Err object:
http://msdn.microsoft.com/en-us/library/sbf5ze0e(v=vs.85).aspx
On Error:
http://msdn.microsoft.com/en-us/library/53f3k80h(v=vs.85).aspx
On Error Statement
11 out of 21 rated this helpful
Enables or disables error-handling.
Copy
On Error Resume Next
On Error GoTo 0
Remarks
If you don't use an On Error Resume Next
statement anywhere in your code, any run-time error that occurs can cause an
error
message to be displayed and code execution stopped. However, the host running
the
code determines the exact behavior. The host can sometimes opt to handle such
errors
differently. In some cases, the script debugger may be invoked at the point of
the
error. In still other cases, there may be no apparent indication that any error
occurred
because the host does not need to notify the user. Again, this is purely a
function
of how the host handles any errors that occur.
Within any particular procedure, an error is not necessarily fatal as long as
error-handling
is enabled somewhere along the call stack. If local error-handling is not
enabled
in a procedure and an error occurs, control is passed back through the call
stack
until a procedure with error-handling enabled is found and the error is handled
at
that point. If no procedure in the call stack is found to have error-handling
enabled,
an error message is displayed at that point and execution stops or the host
handles
the error as appropriate.
On Error Resume Next
causes execution to continue with the statement immediately following the
statement
that caused the run-time error, or with the statement immediately following the
most
recent call out of the procedure containing the
On Error Resume Next
statement. This allows execution to continue despite a run-time error. You can
then
build the error-handling routine inline within the procedure.
An On Error Resume Next statement becomes inactive when another procedure is
called,
so you should execute an
On Error Resume Next
statement in each called routine if you want inline error handling within that
routine.
When a procedure is exited, the error-handling capability reverts to whatever
error-handling
was in place before entering the exited procedure.
Use On Error GoTo 0 to disable error handling if you have previously enabled it
using
On Error Resume Next.
The following example illustrates use of the On Error Resume Next statement.
Copy
On Error Resume Next
Err.Raise 6 ' Raise an overflow error.
MsgBox "Error # " & CStr(Err.Number) & " " & Err.Description
Err.Clear ' Clear the error.
Requirements
Version 1
See Also
Reference
Err Object (VBScript)
Exit Statement
VBScript Run-time Errors
VBScript Syntax Errors
---
This email is free from viruses and malware because avast! Antivirus protection
is active.
http://www.avast.com