Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enumerate all global variables?
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Global Variables | Excel Programming | |||
global variables | Excel Programming | |||
Global variables | Excel Programming | |||
Global Variables | Excel Programming | |||
global variables | Excel Programming |