[求助]怎样把这样一段数据分离到msflexgrid里
2007-09-18 11:06:23 |左机A1#缸排气温度|02007-09-18 11:06:23 |左机A2#缸排气温度|0
2007-09-18 11:06:23 |左机A3#缸排气温度|0
2007-09-18 11:06:23 |左机A4#缸排气温度|0
2007-09-18 11:06:23 |左机A5#缸排气温度|0
2007-09-18 11:06:23 |左机A6#缸排气温度|0
2007-09-18 11:06:23 |左机B1#缸排气温度|0
2007-09-18 11:06:23 |左机B2#缸排气温度|0
2007-09-18 11:06:23 |左机B3#缸排气温度|0
2007-09-18 11:06:23 |左机B4#缸排气温度|0
2007-09-18 11:06:23 |左机B5#缸排气温度|0
2007-09-18 11:06:23 |左机B6#缸排气温度|0
把这一组数据分离到msflexgrid中,我做了个却出现下标越界我不知道为什么会出现这个情况,大家帮帮我
我的代码部分:
Dim i, j, z, p As Integer
Dim splita() As String
Dim splita1() As String
Dim file As Integer
Dim instring As String
Dim filename As String
p = 1
filename = App.Path & "\L-2007-09-18.bsd"
'Debug.Print filename
Open filename For Input As #1
While Not EOF(1)
Line Input #1, instring
'Debug.Print instring
splita = Split(instring, "|")
For i = 0 To UBound(splita)
Debug.Print splita(i)
MSFlexGrid1.TextMatrix(p, i) = splita(i)
Next i
p = p + 1
Wend
Close #1