|
- Sub 显示选定文件夹文件() '调用Windows文件浏览器打开文件
- Range("A:A").ClearContents '清除
- Dim fso, fl, fp, IsRead As Boolean
- Dim wb As Workbook
- Set fso = CreateObject("Scripting.FileSystemObject")
- fp = CreateObject("Shell.Application").BrowseForFolder(0, "请选择文件夹", 0, "").Self.Path & ""
- Dim arr(1 To 10000, 1 To 1)
- For Each fl In fso.getfolder(fp).Files
- IsRead = False
- If InStr(UCase(fl.Name), "TXT") > 0 Then
- Open fl For Input As #1
- Do While Not EOF(1)
- Line Input #1, x '读入每行
- If Trim(x) = "【基金机构持股】" Then IsRead = True
- If Trim(x) = "截止日期:2015-12-31" Then Exit Do
- If IsRead Then
- tmp = Left(Trim(x), 2)
- If tmp <> "【基" And tmp <> "截止" And tmp <> "合 " And tmp <> "──" _
- And tmp <> "机构" And tmp <> "" Then x = Left(fl.Name, Len(fl.Name) - 4) & " " & x
- n = n + 1: arr(n, 1) = x
- End If
- Loop
- Close #1
- End If
- Next
- If n > 0 Then [a1].Resize(n, 1) = arr
- End Sub
复制代码 通过一些关键词判断哪些内容前不加代码。 |
|