1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
|
Sub ecriredepuisrelaidansexcel()
Dim ifile As Integer
ifile = FreeFile
Dim x
Dim a1, a2, a3, a4, a5, a6, a7, a8, a9, a10
Open "C:\Documents and Settings\Bill\Bureau\relai.txt" For Input As #ifile
x = 1
Do While Not EOF(1)
Input #ifile, a1, a2, a3, a4, a5, a6, a7, a8, a9, a10
'boucle possible
Cells(x, 1) = a1: Cells(x, 2) = a2: Cells(x, 3) = a3: Cells(x, 4) = a4: Cells(x, 5) = a5: Cells(x, 6) = a6
Cells(x, 7) = a7: Cells(x, 8) = a8: Cells(x, 9) = a9: Cells(x, 10) = a10
x = x + 1
Loop
Close #ifile
End Sub |
Partager