re,
Merci m3ellem1,
voici une nouvelle version pour modifier tous les fichier.txt d'un répertoire,
ps / sans l'utilisation d'une feuille
Option Explicit
'ajouter la référence Microsoft Scripting Runtime
Sub test3()
Dim oFSO As Scripting.FileSystemObject
Dim oFl As Scripting.file
Dim oTxt As Scripting.TextStream
Dim oFile, sfoFolder
Dim s, i As Long, rw As Long, n As Integer, t As String, Var As String, Nouveufichier As String
Dim tbl()
Set oFSO = New Scripting.FileSystemObject
Set sfoFolder = oFSO.GetFolder("C:\Users\isabelle\Documents\Test11") '<--répertoire à adapter
For Each oFile In sfoFolder.Files
If LCase(Right(oFile, 4)) = ".txt" Then
Set oFl = oFSO.GetFile(oFile)
Set oTxt = oFl.OpenAsTextStream(ForReading)
s = Split(oFile, ".")
Nouveufichier = s(0) & "(corr).txt"
rw = 0
While Not oTxt.AtEndOfStream
rw = rw + 1
ReDim Preserve tbl(rw)
tbl(rw) = oTxt.ReadLine
Wend
Set oTxt = oFSO.CreateTextFile(Nouveufichier)
For i = LBound(tbl) To UBound(tbl)
If i = 1 Then Var = "Temps" Else Var = "00:00:01"
s = Split(tbl(i), Chr(9))
For n = LBound(s) To UBound(s)
Select Case n
Case 1: t = t & s(n) & Chr(9) & Var & Chr(9)
Case Else: t = t & s(n) & Chr(9)
End Select
Next n
oTxt.WriteLine t
t = ""
Next i
End If
Next oFile
End Sub