Hi All, Im pretty new to vba programming Ive developed simple vb apps i
the past but never needed to connect to a database.

What do I need to do setup the connection, Ive currently got this in m
code and throws up an error message:

Dim cn as ADODB.Connection
Set cn = New ADODB.Connection
With cn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "Data Source=C:\MyFolder\MyWorkbook.xls;" & _
"Extended Properties=Excel 8.0;"
.Open
End With

When I try to run it I get the error: User defined type not define
for the ADODB.Connection so I havnt set this up correctly I have MDA
2.5 already installed so what else do I need to setup.

Thanks in Advance

--
NOODLES10148
-----------------------------------------------------------------------
NOODLES101487's Profile: http://www.hightechtalks.com/m8
View this thread: http://www.hightechtalks.com/t226110