VBE References List
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
|