Sub ExportTxtChamp()
repertoire = ThisWorkbook.Path
Open repertoire & "\essai.txt" For Output As #1
Set champ = [B1].CurrentRegion
Dim lg(): ReDim lg(1 To champ.Columns.Count)
For i = 1 To champ.Columns.Count
lg(i) = champ.Cells(1, i).Width / 5
Next i
For lig = 1 To champ.Rows.Count
ligne = ""
For col = 1 To champ.Columns.Count
ligne = ligne & champ.Cells(lig, col).Text
If lg(col) - Len(champ.Cells(lig, col).Text) > 0 Then
ligne = ligne & String(lg(col) - Len(champ.Cells(lig, col).Text), " ") & " "
Else
MsgBox "la colonne:" & col & " n'est pas assez large"
Stop
End If
Next col
Print #1, Left(ligne, Len(ligne) - 1)
Next lig
Close #1
End Sub