Sub Macro3()
'
' Macro3 Macro
'
'
With ActiveWorkbook.Connections("instruction").ODBCConnection
.BackgroundQuery = False
.CommandText = Array( _
"SELECT *" & Chr(13) & "" & Chr(10) & "FROM BASE_INSTRUCTIONS" & Chr(13) & "" & Chr(10) & "where `agence de regroupement`= 'Agence PARIS'" _
)
.CommandType = xlCmdSql
.Connection = Array(Array( _
"ODBC;DSN=MS Access Database;DBQ=N:\Automatisation Share.accdb;DefaultDir=N:\;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeou" _
), Array("t=5;"))
.RefreshOnFileOpen = False
.SavePassword = False
.SourceConnectionFile = ""
.ServerCredentialsMethod = xlCredentialsMethodIntegrated
.AlwaysUseConnectionFile = False
End With
With ActiveWorkbook.Connections("instruction")
.Name = "instruction"
.Description = ""
End With
ActiveWorkbook.Connections("instruction").Refresh
End Sub