|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
本帖最后由 不知道为什么 于 2018-10-18 18:36 编辑
参考
- Sub 汇总()
- Dim Wbk As Workbook, Arr, Brr()
- Dim MyPath$, Fn, i&,x&
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- MyPath = ThisWorkbook.Path & ""
- Fn = Dir(MyPath & "*.xl*")
- ReDim Brr(1 To 9999, 1 To 3)
- Do While Fn <> ""
- If Fn <> ThisWorkbook.Name Then
- Set Wbk = Workbooks.Open(MyPath & Fn)
- With Wbk
- ms = Left(.Name, 1)
- Arr = .Sheets(1).Range("a1").CurrentRegion
- .Close
- End With
- For i = 2 To UBound(Arr)
- x = x + 1
- Brr(x, 1) = ms
- Brr(x, 2) = Arr(i, 1)
- Brr(x, 3) = Arr(i, 2)
- Next i
- End If
- Fn = Dir
- Loop
- With ActiveSheet
- .Cells.ClearContents
- .[a1].Resize(1, 3) = Array("姓名", "日期", "数量")
- .[a2].Resize(x, 3) = Brr
- End With
- Erase Brr
- Application.DisplayAlerts = True
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|