Error ADO Connection Macro Excell
Tengo un marco en excel que ya estaba funcionando pero hace unos días mi computadora realizo algunas actualizaciones y ahora me aparece este error

Private Sub Worksheet_Change(ByVal Target As Range)
Dim KeyCells As Range
Set KeyCells = Range("C1")
If Not Application.Intersect(KeyCells, Range(Target.Address)) _
Is Nothing Then
' Inicia codigo para las recuperaciones
Application.ScreenUpdating = False
Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim sql As String
Dim x As Long, y As Long, i As Long, SQL_Rec As String
For i = 1 To 50
Set cnn = New ADODB.Connection
Set rst = New ADODB.Recordset
If Left(Cells(i + 1, 1).Value, 1) = "Z" Or Left(Cells(i + 1, 1).Value, 1) = "T" Then
sql = "Select sum(total) as Total From TBL_Rep_Prin Where Ncut ='" & Cells(i + 1, 1).Value & "' and area_resp = 'Piel' and status = 'entregado' and semana = '" & Cells(1, 3).Value & "'"
'MsgBox sql
With cnn
.Provider = "Microsoft.ACE.OLEDB.12.0"
.ConnectionString = "data source= \\matfile\data\shared\Databases\ Recuperaciones\Recuperaciones.accdb"
.Open
End With
With rst
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Open sql, cnn, , , adCmdText
End With
rst.MoveFirst
Cells(i + 1, 6).Value = rst("total")
rst.MoveNext
Set rst = Nothing
Set cnn = Nothing
Else
End If
Next i
' Termina codigo de Recuperaciones
Application. ScreenUpdating = True
MsgBox "Updated", vbInformation
End If
End Sub Estas son las librerias que tengo cargadas.

Respuesta de Abraham Valencia
1

