1 2 3 4 5 6 7 8 9 10 11 12 13
| Sub test1()
Dim Chemin As String, Variable As String, Fichiers As Variant, I As Integer, Plage As Range
Chemin = "C:\Users\dcola\OneDrive\mpfe"
Variable = "toto"
Set Plage = Range("A1")
Fichiers = Array("test1.txt", "test1.txt", "test1.txt", "test1.txt", "test1.txt", _
"test1.txt", "test1.txt", "test1.txt", "test1.txt", "test1.txt")
For I = 0 To 9
Workbooks.OpenText Chemin & "\" & Fichiers(I), DataType:=xlDelimited, Tab:=True
Cells.Replace Variable, Plage.Offset(I).Value
ActiveWorkbook.Close True
Next I
End Sub |
Partager