PDA

View Full Version : Solved: Dump Call Stack



CareerChange
04-19-2011, 11:14 AM
Is there any way to dump the Call Stack at the time an error handler is invoked?

Specifically, my various error handlers are working as designed, however I would like to capture and dump the active Call Stack to a separate "diagnostics worksheet" rather than having an end-user explain what they were doing at the time when the error occurred.

To be clear, I already capture the err.Source and Description, but I want/need more than that.

Thank you!

Bob Phillips
04-19-2011, 01:18 PM
I build my own stack, it is code-intensive, but I am not aware how you can access the VBE stack.

CareerChange
04-19-2011, 01:47 PM
Thank you for the quick reply, however not having access to the stack and other detailed diagnostic information is a major drawback for VBA when compared to other languages.

Win some... lose some.

Bob Phillips
04-19-2011, 02:13 PM
Agreed, but it is a 15 year old product now that is going nowhere.