I'm trying to write a general error hadler to incorperate in any new VBA project I'm working on.

Is there a way to return the project, module and line which caused the error?

The err object only has number, description, helpcontext, helpfile, lastDLLerror, and source properties. I thought the source property would be useful but it only returns the name of the object or application which originated the error (not the specific line of code and module in which it exists)

Any help or pointers to good sites with help on creating comprehensive error handling would be appreciated.

TIA