coltot = ActiveSheet.UsedRange.Columns.Count
lignetot = ActiveSheet.UsedRange.Rows.Count
tablo = Range(Cells(1, 1), Cells(lignetot, coltot)).value
Nb = FreeFile
Open "c:\fichier.txt" For Append As #Nb
Texte = tablo(n, 1) & ";" & Cells(1, 6).value & ";" & Cells(1, 7).value & ";"
For c = 2 To 5
Texte = Texte & FormatNumber(tablo(n, c), 2) & ";"
Next
Texte = Texte & Cells(1, 8).value & ";"
Print #Nb, Left(Texte, Len(Texte) - 1)
Texte = ""
Close #Nb
End If