Dennis,

Add a Reference to 'Visual Basic for Applications Extensibility'.

Rob


"DennisE" wrote in message
...
To check whether early binding to external libraries
is in place, I have incorporated the routine shown on page
512 of Excel 2002 VBA by Bulen/Green/Bovey/Rosenberg
as part of my Auto_Open macro. Here are the core lines:

Sub Auto_Open()
Dim ref as Object
For each ref In ThisWorkBook.VBProject.References
If ref.IsBroken Then
MsgBox ref.Name & " is broken; please reinstall."
Next

My question is, search as I may, I cannot find any mention
(let alone description) of the IsBroken property anywhere else
in the world. Certainly not in the Object Browser as a class,
member, or element of any Library, not in the MS Knowledge
Base, or through a Google search. Excel seems to accept
IsBroken as a legimate property of an object reference, so why
isn't it documented somewhere?

-- Dennis Eisen