View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
VBA Dabbler[_2_] VBA Dabbler[_2_] is offline
external usenet poster
 
Posts: 54
Default 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