1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| Sub recherche5()
Dim maStr As String, a$
Dim i As Integer
Dim T As Variant
Open "C:\Users\Fred\Desktop\MGMPLDAT.txt" For Input As #1
While Not EOF(1)
Line Input #1, a$
If Left(a$, 1) Like "5" And Len(a$) = 35 Then 'à vérifier pour le 35
Do
Line Input #1, a$
maStr = maStr & ", " & Left(a$, 4)
Loop Until a$ = "$"
End If
Wend
Close #1
maStr = Right(maStr, Len(maStr) - 2)
maStr = Left(maStr, Len(maStr) - 3)
T = Split(maStr, ", $,")
For i = 0 To UBound(T)
Debug.Print T(i)
MsgBox T(i)
Next i
End Sub |
Partager