ellebanna

If i have this procedure for example:

Sub Main()
On error goto x
code -------
code--------
subroutine()
exit sub
x:
--log error here
End sub

Sub subroutine()
On error goto y
code
exit sub
y:
log error
err.clear
Exit sub

Question: If i clear the error in the subroutine, will it still kill the whole process or will it think that there is no longer an error when it goes back to main() ?

Flyguy

If the error is handled you will not get into a higher level error handler, no matter whether you cleared the err object or not.

ellebanna

Thanks.
So what is the best way to handle the error so i can log where the error has occured in a more specific breakdown. I guess what I'm asking is if the error occured in the subroutine, i would like to log the error that it occured in the subroutine, not in main.

jaxbot

Normally, if you use the "On error" commands, it will ignore the error, so long as it's not critical (eg missing DLL file).

Stalemate

The error is not ignored, it's directed to the specified handler.
Now your handler can do what it wants with the error. Log it, notify the user, try fixing the problem itself.
Errors should not be ignored...

To recieve information about errors in a subroutine you can use a return value from the function to determine success or error specification.
Note that an 'On Error' statement is effective for subroutines called from the main procedure containing the statement.
Example: (run the following and see what happens)