|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub test() '后台打开
- Dim wb As Workbook
- Dim sht As Worksheet
- Dim pat As String, nam As String
- Dim arr, i As Integer
- Application.ScreenUpdating = False
- pat = ThisWorkbook.Path
- nam = Dir(pat & "" & "*.xls")
- Do While nam <> ""
- If nam <> ThisWorkbook.Name Then
- Set wb = GetObject(pat & "" & nam)
- Set sht = wb.Sheets(1)
- i = i + 1
- If i = 1 Then
- arr = sht.UsedRange
- ThisWorkbook.Sheets(1).Range("a1").Resize(UBound(arr), UBound(arr, 2)) = arr
- Else
- arr = sht.UsedRange.Offset(1, 0)
- ThisWorkbook.Sheets(1).Range("a65536").End(xlUp).Offset(1, 0).Resize(UBound(arr), UBound(arr, 2)) = arr
- End If
- Windows(wb.Name).Visible = True
- wb.Close False
- End If
- nam = Dir
- Loop
- Application.ScreenUpdating = False
- Erase arr
- Set wb = Nothing
- MsgBox "数据汇总完毕。"
- End Sub
复制代码 |
|