|
- Sub Macro1()
- Dim mypath$, wj$, arr, brr, i&, j%, s&
- ReDim brr(1 To 20000, 1 To 200)
- mypath = ThisWorkbook.Path & ""
- wj = Dir(mypath & "*.xls*")
- Sheet1.Activate
- zf = [b1]
- Application.ScreenUpdating = False
- Do While wj <> ""
- If wj <> ThisWorkbook.Name Then
- With GetObject(mypath & wj)
- arr = .Sheets(1).Range("a1").CurrentRegion
- wb = .Name
- .Close 0
- End With
- For i = 1 To UBound(arr)
- If arr(i, 1) Like "*" & zf & "*" Then
- s = s + 1
- For j = 1 To UBound(arr, 2)
- brr(s, j) = arr(i, j)
- Next
- brr(s, UBound(arr, 2)) = wb
- End If
- Next
- End If
- wj = Dir
- Loop
- Sheet2.Activate
- Range("a1").Resize(s, UBound(arr, 2) + 1) = brr
- Application.ScreenUpdating = True
- End Sub
复制代码 |
评分
-
查看全部评分
|