|
- Sub test()
- Dim r%, i%
- Dim arr, brr(1 To 1000, 1 To 8)
- Dim wb As Workbook
- Dim ws As Worksheet
- Dim mypath$, myname$
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- mypath = ThisWorkbook.Path & ""
- myname = Dir(mypath & "*.xls*")
- m = 0
- Do While myname <> ""
- If myname <> ThisWorkbook.Name Then
- m = m + 1
- Set wb = GetObject(mypath & myname)
- With wb
- With .Worksheets(1)
- r = .Cells(.Rows.Count, 1).End(xlUp).Row
- arr = .Cells(r, 1).Resize(1, 8)
- For j = 1 To UBound(arr, 2)
- brr(m, j) = arr(1, j)
- Next
- End With
- .Close False
- End With
- End If
- myname = Dir()
- Loop
- With Worksheets("sheet1")
- .UsedRange.Offset(3, 0).ClearContents
- .Range("a4").Resize(UBound(brr), UBound(brr, 2)) = brr
- End With
- End Sub
复制代码 |
|