I have created a generic error handling routine that records the nature of runtime errors in a table. As part of this error routine I want to retrieve the name of the current proocedure (that the error occured in) in VBA.
Does anybody know how to do this? The only answer I have found so far is to declare a string constant at the beginning of each procedure - which is far from satisfactory.
Ed Metcalfe.
Does anybody know how to do this? The only answer I have found so far is to declare a string constant at the beginning of each procedure - which is far from satisfactory.
Ed Metcalfe.