Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA References List
Is there anyway to get a list of ALL references available to VBA projects?
I know how to get the references that are active (i.e., checkmarked) for a particular VBproject, but i don't know how to get the un-checkmarked references. Any help would be appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA References List
It's in the registry: HKEY_CLASSES_ROOT\TypeLib
Rob "R Avery" wrote in message ... Is there anyway to get a list of ALL references available to VBA projects? I know how to get the references that are active (i.e., checkmarked) for a particular VBproject, but i don't know how to get the un-checkmarked references. Any help would be appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA References List
I must confess that i have never worked with the registry before. Is there
a tutorial online anywhere on how to use it properly? I have been warned by a co-worker to be careful when using it because problems might arise... "Rob van Gelder" wrote in message ... It's in the registry: HKEY_CLASSES_ROOT\TypeLib Rob "R Avery" wrote in message ... Is there anyway to get a list of ALL references available to VBA projects? I know how to get the references that are active (i.e., checkmarked) for a particular VBproject, but i don't know how to get the un-checkmarked references. Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to list what references any givin hyperlink in excel | Excel Discussion (Misc queries) | |||
Extract External Data according to a list of references | Excel Discussion (Misc queries) | |||
Excel 2002 : How to extract references from a list ? | Excel Discussion (Misc queries) | |||
How do I ignore blanks within my list without losing references? | Excel Discussion (Misc queries) | |||
List of GUIDs and other properties for future references | Excel Programming |