Access.References Name or Description

Is there a way to get the Full Name of Access.References programmatically?



I can get the short name using:

Function CheckReferences()

Dim ref As Reference

Dim refName As String



For Each ref In Access.References

Debug.Print ref.Name & " " & ref.FullPath & " " & ref.Major & "." & ref.Minor

Next ref

End Function

But the Result is like:

VBA

Access

DAO

What we commonly see in the Tools\References Dialog Box is like:

Visual Basic for Applications

Microsoft Access 12.0 Object Library

Microsoft Office 12.0 Access database engine Object Library

I'd like to return the common name as we see it in the Dialog Box.

Is it in the ref.collection(???) maybe? If so, how do I address that information?



Thanks for any help,

Goh

Access.References Name or Description