1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| Sub Traitement()
Dim Plage As Range
Dim Fichier As String, Chaine As String, ChaineFinale As String
Dim L As Long
Dim F As Integer, C As Integer
Set Plage = Sheets(1).UsedRange
Set Plage = Plage.Offset(1, 2).Resize(Plage.Rows.Count - 1)
F = FreeFile()
Fichier = Replace(ThisWorkbook.FullName, ".xls", ".Data")
Open Fichier For Output As #F
For L = 1 To Plage.Rows.Count
Chaine = Plage.Cells(L, 1)
For C = 2 To Plage.Columns.Count
Chaine = Chaine & " " & Plage.Cells(L, C)
Next C
ChaineFinale = ChaineFinale & Chaine & vbLf
Next L
Print #F, RTrim(ChaineFinale);
Close #F
End Sub |
Partager