Thanks Jake,
This was a big help !
Pierre

Jake Marx wrote:
Hi Pierre,

private sub test()
on error goto errorhandling
[quoted text clipped - 10 lines]
want tot execute, do i have to put the 'on errror' codelines also in
the module is is it enough to have it in the main code above?

It depends on what you want the code to do. By default, if you call a
function or subroutine, and it has no error handling of its own, the error
will be "passed up" to the calling code. So the error handler for this sub
"test" will catch the error. If the other function or subroutine does have
error handling, it will catch the error, and you can decide what to do with
it there.

BTW, it's best to use a Resume statement after you trap an error, as the
next error your code encounters will be untrappable if you don't. Here's
what I typically do:

Sub Test()
On Error GoTo ErrHandler

'/ code here

ExitRoutine:
'/ clean up here (set object vars to Nothing, etc)
Exit Sub
ErrHandler:
'/ handle error here if needed
Resume ExitRoutine
End Sub



--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200511/1