• Home
 · 
• Miscellaneous
 · 
• Finding Broken references of your VBA Project through Code. This code reveals the Reference Name,Br

Finding Broken references of your VBA Project through Code. This code reveals the Reference Name,Br

Finding Broken references of your VBA Project through Code. This code reveals the Reference Name,Broken status,Physical Path of Reference,is

Rate Finding Broken references of your VBA Project through Code. This code reveals the Reference Name,Br

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

Dim i As Integer
    
    For i = 1 To Application.References.Count
    
        'Get Reference Name, Broken status
        Debug.Print i & "." & Application.References(i).Name & "---" & Application.References(i).IsBroken
        'Warn User if a Broken Reference is in the application
            If Application.References(i).IsBroken = True Then
                MsgBox Application.References(i).Name & "is not loaded properly", vbCritical
                Exit Function
            End If
        'Get Full Path of Reference
        Debug.Print i & "." & Application.References(i).FullPath
        'Is the reference Built In
        Debug.Print i & "." & Application.References(i).BuiltIn
        'Get the Reference GUID
        Debug.Print i & "." & Application.References(i).Guid
        'Get the Reference Major version & Minor Version
        Debug.Print i & "." & Application.References(i).Major & "." & Application.References(i).Minor
        
    Next

End Function