参与一下。。。
- Sub ykcbf() '//2024.6.13
- Application.ScreenUpdating = False
- Set fso = CreateObject("scripting.filesystemobject")
- Set sh = ThisWorkbook.Sheets("Sheet1")
- p = ThisWorkbook.Path & ""
- Set ff = fso.GetFolder(p)
- b = [{"f2","a3","e3","a4","a4","a5","a6","a7","a8","g8","a9","g9","a10","g10","a11","g11","a12","g12","a13","g13","a32"}]
- ReDim brr(1 To 10000, 1 To UBound(b))
- For Each fd In ff.SubFolders
- For Each f In fd.Files
- If LCase$(f.Name) Like "*.xls*" Then
- fn = fso.GetBaseName(f)
- Set wb = Workbooks.Open(f, 0)
- m = m + 1
- With wb.Sheets(1)
- For j = 1 To UBound(b)
- brr(m, j) = .Range(b(j))
- Next
- End With
- wb.Close False
- End If
- Next f
- Next fd
- With sh
- .[a2:o10000] = ""
- .[a2].Resize(m, 15) = brr
- End With
- Application.ScreenUpdating = True
- MsgBox "OK!"
- End Sub
复制代码
|