Error logging in VBA

[HappySpleen]

Hello all,

I need to know if it is possible to have error handling that can make and save a time stamped text file that contains all the information that I could need to recreate the error later.

What I need it to do is:

1. Log what Form, Module or Class Module the error occurred in
2. What function or Sub the error occurred in
3. What line of code the error occurred in
4. What data was being processed at the time (String, long, Range ... ...)
5. To save the error as a text file saved as the date and time it is created

The reason for trying to log the data that was being processed is I needed to make sure that I was processing the data correctly so any small change can cause it to fail. I have never worked with error handling before so I am a bit lost as to how I would do this and any help is appreciated.

 

[CalcSux78]

Read up on this article: www.fmsinc.com/free/newtips/vba/errorhandling/linenumber.html

In order to get all of the requested info you will need line numbering in the entire VB Project with errorhandling in each sub/function to call an ErrorReport sub that would create the requested file.

For more info on Error Handling, Chip Pearson has some good info:
www.cpearson.com/excel/errorhandling.htm