|
发表于 2016-4-1 10:17
|
显示全部楼层
本楼为最佳答案
本帖最后由 dsmch 于 2016-4-1 10:30 编辑
07以上版本,getobject可能无法使用- Sub Macro1()
- Dim arr, brr, i&, j%, s&
- ReDim brr(1 To 60000, 1 To 4)
- mypath = ThisWorkbook.Path & "\原始数据"
- wj = Dir(mypath & "*.xls*")
- Application.ScreenUpdating = False
- Do While wj <> ""
- With Workbooks.Open(mypath & wj)
- arr = .Sheets("成果").[a1:c10]
- For i = 1 To UBound(arr)
- s = s + 1
- brr(s, 1) = .Name
- For j = 1 To UBound(arr, 2)
- brr(s, j + 1) = arr(i, j)
- Next
- Next
- .Close 0
- End With
- wj = Dir
- Loop
- Range("a1").Resize(s, UBound(brr, 2)) = brr
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|