ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA References List (https://www.excelbanter.com/excel-programming/287433-vba-references-list.html)

R Avery

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.



Rob van Gelder[_4_]

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.





R Avery

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.








All times are GMT +1. The time now is 01:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com