|
- Sub tt()
- xname = [e1]
- Dim brr(1 To 100, 1 To 3)
- Set fso = CreateObject("scripting.filesystemobject")
- For Each f In fso.getfolder(ThisWorkbook.Path).Files
- If InStr(f, ThisWorkbook.Name) = 0 Then
- Set wb = Workbooks.Open(f)
- arr = wb.Sheets(1).[a1].CurrentRegion
- For i = 2 To UBound(arr)
- If arr(i, 1) = xname Then
- n = n + 1
- brr(n, 1) = arr(i, 1): brr(n, 2) = arr(i, 2): brr(n, 3) = arr(i, 3)
- End If
- Next
- wb.Close False
- End If
- Next
- If n > 0 Then [a2].Resize(n, 3) = brr
- End Sub
复制代码 |
|