Hey guys, this is giving me some serious trouble so any help is much appreciated. One of the people at my work place can't use this excel file I used getting the error:
'Run time error '-2147418113 (8000ffff)': Catastrophic Failure'.
Everyone else can use it perfectly fine.
The code is:
help please !
Any advice is much appreciated
'Run time error '-2147418113 (8000ffff)': Catastrophic Failure'.
Everyone else can use it perfectly fine.
The code is:
Code:
'you must create a connection to the Microsoft ActiveX Data Objects 2.X library
'via Tools>References within the VBE!
strProvider = "Microsoft.ACE.OLEDB.12.0"
strDataSource = Worksheets("Reference").Range("B1").Value
Dim rst As ADODB.Recordset
Dim cnn As ADODB.Connection
With cnn
.ConnectionString = "Provider=" & strProvider & "; Data Source=" & strDataSource & "; User Id=admin;Password=;"
.CursorLocation = adUseClient
.Open
End With
help please !
Any advice is much appreciated