?
Solved

How to access the VBA callstack

Posted on 2010-11-17
3
Medium Priority
?
1,245 Views
Last Modified: 2013-11-27
How can I access the VBA callstack via code?
I didn't know this was even possible before I read this webpage: http://www.everythingaccess.com/vbwatchdog/callstack.htm
0
Comment
Question by:Milewskp
3 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34156024
why don't you download the sampledb and see it in action?
0
 
LVL 59

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 34156185
<<How can I access the VBA callstack via code? >>

  You can't normally, but apparently they've dug into the VBA internals and figured out where the call stack lives in memory.  But there is nothing you on your own can do to read the call stack that I'm aware of.

  You can maintain your own stack by maintaing a collection and then popping things on and off as you enter and exit procedures, but you can't get at the VBA call stack through VBA itself.

JimD.
0
 
LVL 1

Author Closing Comment

by:Milewskp
ID: 34156388
Thanks Jim.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question