Check if ADODB reference is added

[Stevenn]

Hi,

When I use the ADODB library I know it's required that I've added Microsoft ActiveX Data Objects 2.8 Library before I can use my code. If it's now added my code will return an error. Is it possible through VBA to check if the reference is loaded before my line

Dim Connection As ADODB.Connection

?

 

[CharlesChuckieCharles]

Try

Dim MyConnection As ADODB.Connection

cos, Connection may become a reserved word depending on whats loaded