Sub test()
Dim p, f, A(1 To 1000, 1 To 6), i
Application.ScreenUpdating = False
p = ThisWorkbook.Path & "\k\"
f = Dir(p & "*.xlsx")
Do While f <> ""
With Workbooks.Open(p & f)
With .Sheets(1)
i = i + 1
A(i, 1) = .[d3]
A(i, 2) = .[j4]
A(i, 3) = .[h15]
A(i, 4) = .[f15]
A(i, 5) = .[l9]
End With
.Close 0
End With
f = Dir
Loop
If i Then
[b3:f65536] = ""
[b3].Resize(i, UBound(A, 2)) = A
End If
End Sub
ABC2.rar
(28.75 KB, 下载次数: 58)