Dim myData() As String, i As Integer, myStr As String Open "c:\123.txt" For Input As #1 Do Until EOF(1) i = i + 1 Line Input #1, myStr myData = Split(myStr, " ") MsgBox "第" & i & "行有" & UBound(myData) + 1 & "个数据" Loop Close
第3个回答 2010-06-17
数据是用空格分开的? 判断读取一行字符串中的空格数应该就可以了 如果数据之间的空格不是固定的,可以通过从字符到空格再到字符的顺序来判断 for i=0 to len(字符串) if mid(字符串,i,1)=" " then 判断空格 end if next i