Detecting if Library Reference is Missing 1

[OzzieOwl]

Hi

I have some VBA code that references Crystal Reports 8 Library, some users are running older versions of Crystal Reports, and some are running newer versions of Crystal Reports, so I need to detect if a Reference for Crystal Reports 8 Library is MISSING or not so I can disable the routine if it is missing, does anyone know how to do this using VBA.

Thanks in advance

Ozzie Owl

 

[PHV]

Something like this ?
With Application.VBE.ActiveVBProject
For i = 1 To .References.Count
If .References(i).IsBroken Then
Debug.Print "Missing " & .References(i).Name
End If
Next i
End With
You may take a look at References.AddFromFile and .AddFromGUID methods

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244