|
发表于 2012-2-23 09:50
|
显示全部楼层
本楼为最佳答案
- Sub test()
- Dim A() As String, B(), C
- Dim i&, j&, s&, Op
-
- '选取文本
- Op = Application.GetOpenFilename()
- If Op = False Then End
-
- '导入数组
- Open Op 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
复制代码
这样,你得确保你选择的是文本文件,
否则,可能读取错误
|
|