ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Return Procedure Name (https://www.excelbanter.com/excel-programming/293447-return-procedure-name.html)

tod

Return Procedure Name
 
I have my code append to a text file if there is an error. But the
results are vague. I'm just having it append the Err.Description to
the file. Err.Source doesn't tell me much. Is there a way I can also
append the procedure name where the error occured? Even better would
be the procedure name AND line number. But.. one can dream, I suppose.

Any suggestions or related help appreciated.

tod

Bob Phillips[_6_]

Return Procedure Name
 
The procedure name is not available as far as I know, so you would have to
manage it yourself. One way would be to have a global public variable, and
set that whenever a procedure is entered.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"tod" wrote in message
m...
I have my code append to a text file if there is an error. But the
results are vague. I'm just having it append the Err.Description to
the file. Err.Source doesn't tell me much. Is there a way I can also
append the procedure name where the error occured? Even better would
be the procedure name AND line number. But.. one can dream, I suppose.

Any suggestions or related help appreciated.

tod




Tom Ogilvy

Return Procedure Name
 
Look at Stephen Bullen's information on ERL

http://tinyurl.com/2fh2u

and on his central error routine. Read the entire thread.

--
Regards,
Tom Ogilvy

"tod" wrote in message
m...
I have my code append to a text file if there is an error. But the
results are vague. I'm just having it append the Err.Description to
the file. Err.Source doesn't tell me much. Is there a way I can also
append the procedure name where the error occured? Even better would
be the procedure name AND line number. But.. one can dream, I suppose.

Any suggestions or related help appreciated.

tod





All times are GMT +1. The time now is 11:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com