Private Sub Command1_Click() Dim b() As Byte, x() As String, s() As String, i As Integer, j As Integer, max As Integer Open "c:\1.txt" For Binary As #1 ReDim b(LOF(1) - 1) Get #1, , b Close #1 x = Split(StrConv(b, vbUnicode), vbCrLf) Erase b max = UBound(x) ReDim s(2, max) For i = 0 To 2 For j = 0 To max s(i, j) = Split(x(j), " ")(i) Debug.Print s(i, j) Next Next Erase x End Sub
Dim b() As Byte, x() As String, s() As String, i As Integer, j As Integer, max As Integer
Open "c:\1.txt" For Binary As #1
ReDim b(LOF(1) - 1)
Get #1, , b
Close #1
x = Split(StrConv(b, vbUnicode), vbCrLf)
Erase b
max = UBound(x)
ReDim s(2, max)
For i = 0 To 2
For j = 0 To max
s(i, j) = Split(x(j), " ")(i)
Debug.Print s(i, j)
Next
Next
Erase x
End Sub