hearthhrob4gals
Board Regular
- Joined
- Aug 20, 2014
- Messages
- 142
hi,
i had this code which worked well previously. today after a long time i tested my macro and got 'error 3706. Provider cannot be found'
Dim cn1 As ADODB.Connection
Set cn1 = New ADODB.Connection
With cn1
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "" & connectName & "" & _
"Extended Properties=Excel 8.0;"
.Open
End With
any help on this would be appreciated
i had this code which worked well previously. today after a long time i tested my macro and got 'error 3706. Provider cannot be found'
Dim cn1 As ADODB.Connection
Set cn1 = New ADODB.Connection
With cn1
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "" & connectName & "" & _
"Extended Properties=Excel 8.0;"
.Open
End With
any help on this would be appreciated