Sub Bouton1_QuandClic()
Dim ligne As String
Dim l As Integer
Open 'C:\\\\\\\\test.txt' For Input As #1 ' a adapter
Do While Not EOF(1)
Line Input #1, ligne
If IsNumeric(Mid(ligne, 1, 1)) Then
l = l + 1
Sheets('outputs').Cells(l, 1) = extraire(ligne)
End If
Loop
Close #1
End Sub
'_________________________________________________
Public Function extraire(t As String) As String
Dim tablo()
Dim i As Byte
For i = 1 To Len(t)
If Mid(t, i, 1) = ' ' Then
x = x + 1
ReDim Preserve tablo(1 To x)
tablo(x) = i
End If
Next i
extraire = Mid(t, tablo(2) + 1)
End Function