Thread: Calling macro?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default Calling macro?

On Mar 13, 2:05*pm, "Rick Rothstein"
wrote:
I believe the name of subroutines, functions, etc., like
variable names, get converted to memory addresses and
bundled into something called a "symbol table"


Yes. But procedures names especially are usually "external" links,
which means that the symbol table usually provides the mapping between
name and address so that a linker can make the "connection" between
caller and callee either at run time (dynamic linkage) or at
(pseudo)compile time.

Moreover, when there is a symbolic debugger, as in VBA, the symbol
table also provides the mapping between even private global and local
variable names and addresses.

So in theory, VBA could provide a method for accessing at least that
information programmatically. Alternatively, the kernel could provide
an API for doing this.

I have implemented both for compiled languages as well as for
interpretive languages. But I do not know if VBA or the Win kernel
makes this available programmatically.