Name of Current Macro running?

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

Hi Nigel,

I think that you would need to add this information to your routines.

MZ Tools adds a button to the VBE which inserts an error handler that
includes the routine and module names.

MZ tools has many other nice features and may be downloaded at:

http://www.mztools.com/


---
Regards,
Norman



"Nigel" <[email protected]> wrote in message
news:[email protected]...
>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
>
>
>
>

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 PrintTheShit()
Const strProcedureName As String = "PrintTheShit"
End Sub

I then use these constants in my err handler.

Hope I helped you a bit
Flemming


"Nigel" <[email protected]> wrote in message
news:[email protected]...
>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
>
>
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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 PrintTheShit()
> Const strProcedureName As String = "PrintTheShit"
> End Sub
>
> I then use these constants in my err handler.
>
> Hope I helped you a bit
> Flemming
>
>
> "Nigel" <[email protected]> wrote in message
> news:[email protected]...
> >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
> >
> >
> >
> >
>
>

Hi Nigel

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

Cheers,
Flemming


"Nigel" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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 PrintTheShit()
>> Const strProcedureName As String = "PrintTheShit"
>> End Sub
>>
>> I then use these constants in my err handler.
>>
>> Hope I helped you a bit
>> Flemming
>>
>>
>> "Nigel" <[email protected]> wrote in message
>> news:[email protected]...
>> >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
>> >
>> >
>> >
>> >
>>
>>
>
>