|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub 汇总()
- Dim arr, brr, i, j, r
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- Set fso = CreateObject("scripting.filesystemobject")
- p = ThisWorkbook.Path & ""
- c = Sheet4.Cells(3, Columns.Count).End(xlToLeft).Column
- ReDim brr(1 To 100000, 1 To c)
- For Each fd In fso.getfolder(p).subfolders
- For Each f In fd.Files
- Debug.Print fd.Name
- Debug.Print f.Name
- Set wb = Workbooks.Open(f)
- Set sh = wb.Sheets(1)
- arr = sh.UsedRange
- wb.Close False
- For i = 2 To UBound(arr)
- If arr(i, 2) <> "" Then
- n = n + 1
- For j = 2 To UBound(arr, 2)
- brr(n, j - 1) = arr(i, j)
- Next
- End If
- Next
- Next
- Next
- With Sheet4
- .UsedRange.Offset(1).ClearContents
- r = .Cells(Rows.Count, 1).End(xlUp).Row
- .Cells(r + 1, 1).Resize(n, c) = brr
- End With
- Application.ScreenUpdating = True
- Application.DisplayAlerts = True
- End Sub
复制代码 |
|