Call Stack.

[Ivar Svendsen]

Hello.


Is it possible to use VBA code to retrieve the Call Stack?
I have one Sub where I need to find out what functions is
calling into my sub.

 

[Phobos]

It may be possible using the windows api, but this is not the right group
for this kind of question.

P

 

[Tim Ferguson]

Is it possible to use VBA code to retrieve the Call Stack?
I have one Sub where I need to find out what functions is
calling into my sub.

Pass it as a parameter...


Tim F

 

[david epsom dot com dot au]

bzzzzt.

Only in this group would you be likely to find
some one who has attempted it, and can tell you
that there is no supported method of getting
the call stack, so you have to create your own
stack, or just pass in the calling name as a
parameter.

You can get some information from the VBA dll's
(none at all from the Win API!), but not what you
want, and it is not - by any conceivable stretch
of the imagination - worth the trouble.....

(david)