Error in editor

[rjmac45]

I am new and pretty raw and there is something basically wrong I know.

Each time I run my module it comes back with Compile Error: user defined Type not defined
and this is what it complains about

Dim objConn As ADODB.Connection

What am I missing?

 

[boblarson]

What am I missing?

A reference to ActiveX. Go to the VBA window and TOOLS > REFERENCES and scroll down until you find the Microsoft ActiveX Data Objects xx.x Library

where xx.x is the latest number available.

 

[rjmac45]

A reference to ActiveX. Go to the VBA window and TOOLS > REFERENCES and scroll down until you find the Microsoft ActiveX Data Objects xx.x Library

where xx.x is the latest number available.

boblarson

Thank You