ADODB.Connection in Excel 1

[Rydel]

The first line of my subroutine in Excel VBA module is the declaration of the ADODB.Connection:

Dim con As New ADODB.Connection

And it stops there with an error message:

User-defined type not defined

Strangely enough, I have a very similar Sub in another Excel file which start with exactly the same declaration and it works. Any help is greatly appreciated!!! ---

http://www.geocities.com/rydel23/

---

 

[MasterPO]

You need to set a Reference to to the ADO dll file. Go to Tools / References. Scroll down to "Microsoft ActiveX Data Objects 2.5" and check the checkbox next to the name. That's it!

 

[Rydel]

Thanks! Actually I figure that out 15 minutes after I submitted my post, but thanks anyway. ---

http://www.geocities.com/rydel23/

---