Sub Ouvre_CSV_Renommé_en_TXT()
'
Dim MyFile As String
'Répertoire = "C:\Users\choupi\Desktop\Bio\"
Répertoire = ThisWorkbook.Path & "\"
MyFile = Dir(Répertoire & "*.txt")
Workbooks.OpenText Filename:= _
MyFile, Origin:=xlWindows, _
StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=True, Tab:=True, Semicolon:=True, Comma:=False, _
Space:=False, Other:=False, FieldInfo:=Array(Array(1, 1), Array(2, 1), Array( _
3, 1), Array(4, 1)), TrailingMinusNumbers:=True
End Sub