7,763
社区成员
发帖
与我相关
我的任务
分享
Sub GetCsvData()
Dim Arr, Ary, k%, i%
Open App.Path & "\Experimental Data\*.csv" For Input As #1
Arr = Split(StrConv(InputB(LOF(1), 1), vbUnicode), vbCrLf): Reset
ReDim Ary(1 To 3, 1 To 1)
For k = 3 To UBound(Arr)
If Arr(k) Like "---*" Then
Exit Sub
Else
i = i + 1
ReDim Preserve Ary(1 To 3, 1 To i)
Ary(1, i) = Split(Arr(k), ",")(0)
Ary(2, i) = Split(Arr(k), ",")(1)
Ary(3, i) = Split(Arr(k), ",")(2)
End If
Next
End Sub