compile error ADODB connection setup

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Error trapping for ADODB.Connection	nod	Microsoft Access Form Coding	1	31st Oct 2007 01:29 PM
ADODB.Connection Error	=?Utf-8?B?TWlrZSBILg==?=	Microsoft Excel Programming	1	7th Aug 2007 08:14 PM
ADODB connection error	=?Utf-8?B?UGFvbGE=?=	Microsoft Access	0	20th May 2006 09:50 AM
compile error... ADODB connection	ina	Microsoft Excel Programming	2	18th Apr 2006 05:41 PM
ADODB.Connection error '800a0e7c'	PJ	Microsoft ASP .NET	1	30th Oct 2003 01:27 PM