Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 220
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,236
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 220
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to list what references any givin hyperlink in excel dijimajik Excel Discussion (Misc queries) 0 September 24th 07 09:34 PM
Extract External Data according to a list of references Sarah (OGI) Excel Discussion (Misc queries) 0 April 20th 07 02:20 PM
Excel 2002 : How to extract references from a list ? Mr. Low Excel Discussion (Misc queries) 6 December 2nd 06 10:48 PM
How do I ignore blanks within my list without losing references? sessc Excel Discussion (Misc queries) 2 July 29th 05 02:53 PM
List of GUIDs and other properties for future references Marc R. Bertrand[_2_] Excel Programming 2 October 28th 03 10:36 AM


All times are GMT +1. The time now is 03:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"