|
发表于 2012-2-11 10:24
|
显示全部楼层
本楼为最佳答案
- Sub test()
- Dim A() As String, B(), C
- Dim i&, j&, s&
- Open ThisWorkbook.Path & "\1.txt" For Input As #1
- A = Split(StrConv(InputB(LOF(1), 1), vbUnicode), vbCrLf)
- Close #1
- ReDim B(1 To 66666, 0 To 9) '预定大小,自行修改
-
- For i = LBound(A) To UBound(A)
- If InStr(A(i), "新华书店") Then
- s = s + 1
- C = Split(A(i), Chr(9))
- For j = 0 To UBound(C)
- B(s, j) = C(j)
- Next j
- End If
- Next i
- [a2].Resize(s, UBound(B, 2)) = B
- End Sub
复制代码
|
|