Sub Feuille_en_CSV_via_tablo()
Dim T(), Fichier As String, Chaine As String
Dim L As Long, f As Integer, c As Integer
Dim dossier As Object, chemin As String
Set dossier = Application.FileDialog(msoFileDialogFolderPicker)
If dossier.Show = 0 Then
Exit Sub
Else
chemin = dossier.SelectedItems(1)
End If
Fichier = chemin & "\" & "Fichier CSV Cargo.csv"
'Application.ScreenUpdating = False
T = Feuil3.Range("A1").CurrentRegion.Value
f = FreeFile()
Open Fichier For Output As #f
For L = 1 To UBound(T, 1)
Chaine = T(L, 1)
For c = 2 To UBound(T, 2)
Chaine = Chaine & ";" & T(L, c)
Next c
Print #f, Chaine
Next L
Close #f
End Sub