|
发表于 2014-10-31 17:51
|
显示全部楼层
本楼为最佳答案
- Sub Macro1()
- Dim mypath$$, wj$$, wb As Workbook, n&, s&
- Application.ScreenUpdating = False
- ActiveSheet.UsedRange.Clear
- mypath = ThisWorkbook.Path & ""
- wj = Dir(mypath & "*.xls*")
- Do While wj <> ""
- If wj <> ThisWorkbook.Name Then
- n = n + 1
- Set wb = GetObject(mypath & wj)
- If n = 1 Then
- wb.Sheets(1).UsedRange.Copy [a1]
- Else
- s = Range("a65536").End(xlUp).Row + 1
- wb.Sheets(1).UsedRange.Offset(1, 0).Copy Cells(s, 1)
- End If
- wb.Close 0
- End If
- wj = Dir
- Loop
- Application.ScreenUpdating = True
- End Sub
复制代码 |
评分
-
查看全部评分
|