List all libraries

pulsar777 · Mar 11th 2017

Hi,
I'd like to list all available Libraries in first column and each level of their respective class and property to next columns,
to compare Office 2010 with 2016 References.

I've managed to list only active references, using elements from MS Visual Basic Extensibility 5.3 library :

Code

Sub List_References()
    
    Dim vp As VBProject
    Dim r As VBIDE.Reference
    Dim vc As VBIDE.VBComponent
    Dim i As Long
    
    Set vp = ActiveWorkbook.VBProject
    
    For Each r In vp.References
        Debug.Print r.Name, r.Description
    Next r


End Sub

Display More

Thank you

pulsar777 · Mar 12th 2017

Re: List all libraries

Is this even possible without adding all libraries?

**Carim** · Mar 12th 2017

Re: List all libraries

Hello,

As far I can recall ... the expert in this area is Chip ...

Have a look at his site : http://www.cpearson.com/excel/vbe.aspx

Hope this will help

pulsar777 · Mar 13th 2017

Re: List all libraries

Thanks Carim, although some useful stuff to be found there,
I didn't find answer to my question.

**pike** · Mar 14th 2017

Re: List all libraries

This is doable
http://www.jkp-ads.com/articles/objectlister.asp
but I have not found a need to use it

**rory** · Mar 14th 2017

Re: List all libraries

Why would you want to list all the available references? They're not necessarily related to Office in any way: some will be down to the Windows version and others to what other software has been installed.

List all libraries

Participate now!

Share