|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub test()
- Application.ScreenUpdating = False
- Dim xlApp As Excel.Application
- Dim xlBook As Excel.Workbook
- Dim sh As Excel.Worksheet
- Dim brr, arr, myab, myc
- brr = Array("a.xlsx", "b.xlsx")
- For Each br In brr
- Set xlApp = New Excel.Application
- Set xlBook = xlApp.Workbooks.Open(ThisWorkbook.Path & "" & br)
- Set sh = xlBook.Worksheets(1)
- myab = sh.UsedRange.Rows.Count
- arr = xlBook.Worksheets(1).Range("a2:d" & myab)
- xlBook.Close False
- myc = Sheet1.UsedRange.Rows.Count
- Cells(myc + 1, 1).Resize(UBound(arr), UBound(arr, 2)) = arr
- Next
- Application.ScreenUpdating = True
- MsgBox "done"
- End Sub
复制代码
|
|