|
发表于 2017-3-29 19:36
|
显示全部楼层
本楼为最佳答案
- Sub test()
- Application.ScreenUpdating = False
- Set fso = CreateObject("scripting.filesystemobject")
- Set ff = fso.getfolder(ThisWorkbook.Path)
- Dim arr(1 To 1000, 1 To 4)
- For Each fff In ff.subfolders
- p = Split(fff, ""): p1 = p(UBound(p))
- For Each f In fff.Files
- q = Split(f, ""): q1 = q(UBound(q))
- Workbooks.Open f
- n = n + 1
- arr(n, 1) = Split(p1, "(")(0)
- arr(n, 2) = Split(q1, "-")(0)
- arr(n, 3) = Split(Split(q1, "-")(1), ".")(0)
- arr(n, 4) = ActiveWorkbook.Sheets(1).[a1]
- ActiveWorkbook.Close False
- Next
- Next
- If n > 0 Then [b18].Resize(n, 4) = arr
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|