Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Does anyone know how to get a list of the libraries available on a machine
using VBA scripting? (That is the list you see when you go to Tools\References in VBE.) I've developed some code which requires certain libraries be present/active, and would like to do some preliminary work to verify and take corrective action, if needed. What I used so far within a For Loop is: 'ActiveWorkbook.VBProject.References.Item(i).Name' This gives me a substantially truncated response which may be the same for different library versions. Regards, VBA Dabbler |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) | |||
VBA References List | Excel Programming |