Calling stack

[Brian.Crawford]

Is there anyway within VBA to get at the calling stack or at least find out within a procedure "who" called it.
Also can a procedure provide its own name (to a variable)

Thanks
Brian

 

[shg]

1. No, but see the Caller property of the Application object.

2. No, other than via a literal string.

 

[Brian.Crawford]

Thanks
B