Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question' ***** Exportation d'un tableau dans un fichier texte (séparateur ;) ' ******************************************************************* Dim Titre As String * 15 Dim Nom1 As String * 30 Dim Nom2 As String * 30 Dim Rue1 As String * 30 Dim Rue2 As String * 30 Dim Nopo As String * 4 Dim Loca As String * 50 Dim Pref As String * 3 Dim Tel As String * 9 Dim Fax As String * 9 Dim Bra As String * 3 Dim Sep As String * 1 Sep = ";" Dim LiFic As String Dim Compt1 As Integer Application.ScreenUpdating = False Open "D:\Mes Documents\Formation\Export.txt" For Output As #1 For Compt1 = 1 To 30 If Cells(Compt1, 1) > " " Then Titre = Cells(Compt1, 1).Value Nom1 = Cells(Compt1, 1).Offset(0, 1).Value Nom2 = Cells(Compt1, 1).Offset(0, 2).Value Rue1 = Cells(Compt1, 1).Offset(0, 3).Value Rue2 = Cells(Compt1, 1).Offset(0, 4).Value Nopo = Cells(Compt1, 1).Offset(0, 5).Value Loca = Cells(Compt1, 1).Offset(0, 6).Value Pref = Cells(Compt1, 1).Offset(0, 7).Value Tel = Cells(Compt1, 1).Offset(0, 8).Value Fax = Cells(Compt1, 1).Offset(0, 9).Value Bra = Cells(Compt1, 1).Offset(0, 10).Value LiFic = Titre & Sep & Nom1 & Sep & Nom2 & Sep & Rue1 & Sep & Rue2 & Sep & Nopo & Sep & Loca & Sep & Pref & Sep & Tel & Sep & Fax & Sep & Bra Print #1, LiFic End If Next Compt1 Close #1 Application.ScreenUpdating = True