Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADODB.Connection Error
I get this error, "Compile Error: User-defined type not defined"
when I try to execute this line of code: Dim cn As ADODB.Connection, rs As ADODB.Recordset, r As Long I copied this code line from a previous thread that was talking about loading data from excel to access. Any ideas what this error is and how to solve it? (The first part of the line seems to be where the error comes from. ) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADODB.Connection Error
You need to add a reference to Microsoft ActiveX Data Objects Library 2.?
In the VBE Select Tools - References - Microsoft ActiveX Data Objects Library 2.? -- HTH... Jim Thomlinson "Mike H." wrote: I get this error, "Compile Error: User-defined type not defined" when I try to execute this line of code: Dim cn As ADODB.Connection, rs As ADODB.Recordset, r As Long I copied this code line from a previous thread that was talking about loading data from excel to access. Any ideas what this error is and how to solve it? (The first part of the line seems to be where the error comes from. ) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ADODB Connection | Excel Worksheet Functions | |||
compile error ADODB connection setup | Excel Programming | |||
ADODB.Connection | Excel Programming | |||
ADODB.Connection | Excel Programming | |||
compile error... ADODB connection | Excel Programming |