Accessing the call stack in an Excel VBA macro?

's Computer Specifications

There is a control which lists the call stack members when you are in the
VBA programming environment. I need to access this from within a VBA macro
at run time. Does anybody have a clue how to do this?

's Computer Specifications

According to Ken Getz in the VBA Developer's Handbook...
"VBA doesn't provide any method for retrieving this information"
--
You would have to write your own code to keep track of calls/releases.
--
Jim Cone
Portland, Oregon USA
(compare stuff, find stuff, remove stuff: http://tinyurl.com/XLCompanion)

"Mike Suman" <(E-Mail Removed)>
wrote in message
There is a control which lists the call stack members when you are in the
VBA programming environment. I need to access this from within a VBA macro
at run time. Does anybody have a clue how to do this?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Call macro stored in Excel workbook from Outlook's macro	=?Utf-8?B?R3ZhcmFt?=	Microsoft Excel Programming	0	4th Oct 2006 05:47 PM
Call macro stored in Excel workbook from Outlook's macro	=?Utf-8?B?R3ZhcmFt?=	Microsoft Outlook VBA Programming	5	4th Oct 2006 06:26 AM
Accessing the CALL STACK	Yahoo	Microsoft C# .NET	11	28th Oct 2005 07:50 AM
Warning 1684 CA2214 : Microsoft.Usage : 'RandomShade..ctor(Int32, Int32, Int32, Int32, Int32)' contains a call chain that results in a call to a virtual method defined by the class. Review the following call stack for unintended consequences:	steve bull	Microsoft C# .NET	4	7th Jul 2005 05:54 PM
walking the call stack from within a thread. Getting the parent call stack	Jason Coyne	Microsoft C# .NET	1	30th Mar 2005 10:30 PM