Enumerate Excel Global variables

[jsp_clarke]

Anyone know if there's a way to enumerate the global variables within
a workbook when opening it for automation?

I know that you can write a macro in a general module that exposes a
variable and then call that macro via:

Excel.Application.Run(MacroName)

But what if you have no control over the development of the Excel
workbook and cannot dictate that a macro be written to expose the
variable you're interested in? In fact in the case I'm dealing with I
don't even know the name of the variable. All I know is that the
workbook may have global variables of a COM component of a certain
type.

Is there some way to get a handle on all the global variables in a
workbook to enumerate through them so you can find the ones you're
interested in?

 

[jaf]

IMHO
The author of the com component obviously did not intend that it be used by others.
Even if you could enumerate the globals you would most likely run into a licensing issue.

Of course, if they were indeed globals, you would be able to see them in the object browser.

John

 

[Bob Phillips]

Get hold of MZTools, the VBA version is free, and that has such a function.

 

[Gord Dibben]

URL.............

http://www.mztools.com/index.aspx


Gord

 

[Bob Phillips]

you molly-coddle them Gord!