1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
| '--MsgBox (valcel)
Dim rsBat3 As ADODB.Recordset
Set rsBat3 = New ADODB.Recordset
strConn = "PROVIDER=SQLOLEDB;"
strConn = strConn & "DATA SOURCE=10.11.7.73;UID=sa;PWD=tenotua"
DerniereLigne3 = Worksheets("CFG").Range("V1000").End(xlUp).Row
For i = 2 To DerniereLigne3
'-MsgBox i
Set f3 = fso.OpenTextFile(chemin & "\SQL\sql-sage-tresorie.sql", ForReading)
une_variable3 = Replace(f3.ReadAll, "nom_compta_sql", Worksheets("CFG").Range("w" & i).Value)
une_variable3 = Replace(une_variable3, "libelle_treso", Worksheets("CFG").Range("x" & i).Value)
une_variable3 = Replace(une_variable3, "datedebut", Format(valceldebut, "yyyymmdd"))
une_variable3 = Replace(une_variable3, "datefin", Format(valcel, "yyyymmdd"))
une_variable3 = Replace(une_variable3, "date_treso", valcel)
une_variable3 = Replace(une_variable3, "societe_treso", Worksheets("CFG").Range("v" & i).Value)
une_variable3 = Replace(une_variable3, "num_code_client", Worksheets("CFG").Range("y" & i).Value)
f3.Close
Set f23 = fso.OpenTextFile(chemin & "\" & Worksheets("CFG").Range("w" & i).Value & "-" & Worksheets("CFG").Range("x" & i).Value & ".txt", 2, True)
f23.write (une_variable3)
f23.Close
With rsBat3
.ActiveConnection = cnBat
.Open une_variable3
Do While Not rsBat3.EOF
DerniereLigne = Worksheets("SQL-tresorerie").Range("A10000").End(xlUp).Row + 1
'MsgBox (DerniereLigne)
Worksheets("SQL-tresorerie").Range("A" & DerniereLigne).CopyFromRecordset rsBat3
Loop
.Close
End With
Next |
Partager