Hi Nigel

I belive that there are more ways - this is just how I do it.

Cheers,
Flemming


"Nigel" wrote in message
...
Thanks for the tips. I had considered the addition of a constant that
would
be used in the err.handler but it seemed a bit onerous to have to set the
value up each time and maintain it, but if that is the only way I guess I
have to pursue it.

I'll take a look at MZ tools and see if it fits.

Thanks again

--
Cheers
Nigel



"Flemming Dahl" wrote in message
...
Hi Nigel

What I do is to make a private const in each module and in each
procedure...
like this

Private Const mstrModuleName As String = "modPrintFeatures"

Public Sub PrintThe****()
Const strProcedureName As String = "PrintThe****"
End Sub

I then use these constants in my err handler.

Hope I helped you a bit
Flemming


"Nigel" wrote in message
...
I am developing a error handling routine and wish to note the name of
the
module and sub that was running when the error occurs.

Is this available ?

--
Cheers
Nigel