Code to check for Reference libraries installed

[sellert]

Is there a way with on-open to check for the reference libraries that is installed on a machine and either, branching to different code suitable for the libraries installed or, displaying a message letting the user know they are missing a required library and to contact IS&T?

Thanks,
SELLERT

If I'm not learning I must be coasting. If I am coasting I must be going down hill.

 

[PHV]

A starting point:

Sub ReferenceInfo()
Dim strMessage As String
Dim refItem As Reference
On Error Resume Next
For Each refItem In References
  If refItem.IsBroken Then
    strMessage = "Missing Reference:" & vbCrLf & refItem.FullPath
  Else
    strMessage = "Reference: " & refItem.Name & vbCrLf _
                 & "Location: " & refItem.FullPath
  End If
  Debug.Print strMessage
Next
End Sub

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886