Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name of Current Macro running?
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" 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name of Current Macro running?
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name of Current Macro running?
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name of Current Macro running?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running total based upon current date | Excel Worksheet Functions | |||
disable user running macro from Tools Macro | Excel Discussion (Misc queries) | |||
Running/Current time in cell? | New Users to Excel | |||
Running a Sub and exiting the current one. | Excel Programming | |||
Launch Macro in Access via Macro running in Excel??? | Excel Programming |