|
发表于 2016-5-30 15:14
|
显示全部楼层
本楼为最佳答案
- Sub Macro1()
- Set sht = ThisWorkbook.Sheets(1)
- mypath = ThisWorkbook.Path & ""
- wj = Dir(mypath & "*.xls")
- Application.ScreenUpdating = False
- [a2:e60000].Clear
- Do While wj <> ""
- If wj <> ThisWorkbook.Name Then
- n = sht.Range("a65536").End(xlUp).Row + 1
- zf = Split(wj, ".xls")(0)
- With GetObject(mypath & wj)
- Set rng = .Sheets(1).Range("a1").CurrentRegion.Offset(1, 0)
- rng.Copy sht.Cells(n, 1)
- sht.Cells(n, 5).Resize(rng.Rows.Count - 1) = zf
- .Close 0
- End With
- End If
- wj = Dir
- Loop
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|