compile error ADODB connection setup
 

I tried using vba to setup a connection as follows
Dim cnn as ADODB.Connection and I get the following compile error:
User-defined type not defined.

I then noticed when I was defining my variable, the option to select ADODB
was not even available...

Do I need to downlaod something for excel? I am running office 2003.

Any help will be greatly appreciated
ToniS

compile error ADODB connection setup
 

you can ignore this post, I found the answer w/i another post



"ToniS" wrote:

I tried using vba to setup a connection as follows
Dim cnn as ADODB.Connection and I get the following compile error:
User-defined type not defined.

I then noticed when I was defining my variable, the option to select ADODB
was not even available...

Do I need to downlaod something for excel? I am running office 2003.

Any help will be greatly appreciated
ToniS