|
- Sub Macro1()
- Dim wb As Workbook, mypath$, wj$
- Dim n&, h&, l&
- mypath = ThisWorkbook.Path & ""
- wj = Dir(mypath & "*.xls")
- n = 1
- Application.ScreenUpdating = False
- Do While wj <> ""
- If wj <> ThisWorkbook.Name Then
- Set wb = GetObject(mypath & wj)
- With wb.Sheets("b")
- h = .UsedRange.Rows.Count
- l = .UsedRange.Columns.Count
- .Range(.Cells(8, 1), .Cells(h, l)).Copy Cells(n, 1)
- n = Range("a65536").End(xlUp).Row + 1
- End With
- wb.Close 0
- End If
- wj = Dir
- Loop
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|