By default every project is initially named VBAProject, therefore the list may contain several identically named items.
To distinguish a project change its name in the Properties window of the original project using the VB Editor.
This is is a list of all the references (libraries) that are being used in this project
You can determine their name, file name and description.
If you add any additional references are these stored in a specific place in the Registry.
Dim icount As Integer
For icount = 1 To Application.VBE.ActiveVBProject.References.Count
Debug.Print "Name: " & .BuiltIn
'Debug.Print "Name: " & .Collection.Item(icount)
Debug.Print "Name: " & .Description
Debug.Print "Name: " & .FullPath
Debug.Print "Name: " & .GUID
Debug.Print "Name: " & .IsBroken
Debug.Print "Name: " & .Major
Debug.Print "Name: " & .Minor
Debug.Print "Name: " & .Name
Debug.Print "Name: " & .Type
'Debug.Print "Name: " & .VBE
Checking External References
The VBIDE References collection provides a method of checking that all the application's references are installed.
Dim objReference As Object
Dim bBroken As Boolean
Dim sDescription As String
For Each objReference In ThisWorkbook.VBProject.References
If objReference.IsBroken Then
''some broken links do not have descriptions so ignore the error ?
On Error Resume Next
sDescription = "Not Known"
sDescription = objReference.Description
On Error GoTo 0
Call Msgbox ("The following reference is missing:" & vbcrlf & _
"Name: " & sDescription & vbcrlf & _
"Path: " & objReference.FullPath & vbcrlf & _
"This library or file needs reinstalling.")
bBroken = True
If bBroken = True Then End
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext