macro to log error

[excelhelpseeker]

Hello Champs,

I need a macro to log error description in a sheet or in a notepad with date and time and to be saved in a folder

for example, if any macro error, the error description has to be saved in a text file or a xls in a folder.

pls help

[Kaper]

A good place to start is: http://www.cpearson.com/excel/errorhandling.htm
Current error is stored in Err.Number and description in Err.Description
Knowing these two, and how to handle error (link), preparing a log sheet shall be an easy task (txt file will be a bit more demanding).