How can I disable a reference library with VBA code

[S. van Beek]

Dear reader,

I can "able" and "unable" (disable) reference libraries in the reference
form of VBA with Tools/References..

But is there code available in VBA to disable a missing reference.

I have already VBA code with the functionality to check of the reference to
an external library is still available. In case the reference is broken the
checking code runs into an error because the tick box in the reference form
is still active. If I disable the tick box the checking code fore missing
references works perfect.

Now I am looking for VBA code how to unable the missing references in the
reference form of VBA.

Thanks for any help.

Kind regards,

Simon van Beek

[Douglas J. Steele]

Each Reference object has an IsBroken property. You could loop through the
References collection, and delete each Reference object with its IsBroken
property set to True.

You might be interested in reading what MichKa suggests at
http://www.trigeminal.com/usenet/usenet026.asp
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"S. van Beek" <S.******@HCCnet.nl> wrote in message
news:43*********************@reader2.nntp.hccnet.n l...

Dear reader,

I can "able" and "unable" (disable) reference libraries in the reference
form of VBA with Tools/References..

But is there code available in VBA to disable a missing reference.

I have already VBA code with the functionality to check of the reference
to
an external library is still available. In case the reference is broken
the
checking code runs into an error because the tick box in the reference
form
is still active. If I disable the tick box the checking code fore missing
references works perfect.

Now I am looking for VBA code how to unable the missing references in the
reference form of VBA.

Thanks for any help.

Kind regards,

Simon van Beek