OceanStars
asked on
Excel 2003 Connection error message "User-defined type not defined"
From Excel 2003 need to connect to Access database.
This line of VB code in the Visual Basic Editor
Dim cnn As ADODB.Connection
always gives error message : "User-defined type not defined"
This line of VB code in the Visual Basic Editor
Dim cnn As ADODB.Connection
always gives error message : "User-defined type not defined"
Dim cnn As ADODB.Connection
Set cnn = New adodb.Connection
With cnn
.ConnectionTimeout = 500
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "Data Source=" & strPathToDB & ";"
.Open
.CommandTimeout = 500
End With
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER