|
Option Explicit
Sub test()
Dim i, s, t, f, arr
f = ThisWorkbook.Path & "\test.txt"
If Dir(f) = vbNullString Then MsgBox f: Exit Sub
Open f For Input As #1
arr = Split(StrConv(InputB(LOF(1), 1), vbUnicode), vbNewLine)
Close #1
ReDim brr(UBound(arr), 1 To 2)
s = String(4, "-")
For i = 0 To UBound(arr)
If InStr(arr(i), s) Then
t = Split(arr(i), s)
brr(i, 1) = t(1): brr(i, 2) = t(2)
End If
Next
With [a2]
.Resize(Rows.Count - 1, 2).ClearContents
.Resize(UBound(brr, 1) + 1, 2) = brr
End With
End Sub |
评分
-
1
查看全部评分
-
|