Getting reference information

[dinotom]

I am stumbling on how to retrieve the information on all references that are set in a vbproject using Excel 2010. So that I can test for the references a certain project requires and set them via code if necessary. I have tried various ways, all are breaking. MSDN wasn't that helpful.

 

[Andrew Poulsom]

Why do you need to set them via code? References travel with the workbook.

 

[Sektor]

Sub AllRefs()

    Dim ref As Object
    For Each ref In ThisWorkbook.VBProject.References
        MsgBox ref.Description
    Next

End Sub

 

[Sektor]

For this to work check checkbox:
File -> Options -> Trust Center -> Trust Center Settings -> Macro Settings -> Trust access to the VBA project object model.

Sub AllRefs()
    
    ' Tools -> References -> Microsoft Visual Basic for Applications Extensibility 5.3
    
    Dim ref As Reference
    
    For Each ref In ThisWorkbook.VBProject.References
        MsgBox ref.Description
    Next

End Sub

 

[dinotom]

thank you

 

[dinotom]

Andrew,

The reason I want to set them via code is because if you create the workbook in excel 2010 for example and someone runs it on excel 2007 then you get a reference error and the Outlook 2010 reference, for example, shows as MISSING in the references. So I want to test for version number and set them accordingly

 

[Andrew Poulsom]

In that case I would use late binding.

 

[dinotom]

Can anyone point me as to where I can find the other methods under VBProject besides References? I don't see them in Object Browser or on MSDN

 

[Sektor]

Look here

 

[dinotom]

Helpful, but I'm looking for a table of all the references GUID info
(for example) VBProject.References.AddFromGuid("{0002E157-0000-0000-C000-000000000046}", 0, 0)
so I can have a reference lookup for the app based on what version of Excel the person is running and then set the reference appropriately.