|
- Sub Macro1()
- Dim fs, wb As Object, arr, brr(1 To 10000, 1 To 4)
- Application.ScreenUpdating = False
- Set fs = CreateObject("scripting.filesystemobject")
- For Each m In fs.GetFolder(ThisWorkbook.Path & "").SubFolders
- For Each f In fs.GetFolder(m & "").Files
- Set wb = GetObject(f)
- arr = wb.Sheets(1).Range("a1").CurrentRegion
- wb.Close 0
- y = UBound(arr)
- For j = 1 To UBound(arr, 2)
- If arr(1, j) = arr(y - 1, j) And arr(2, j) = arr(y, j) Then
- s = s + 1
- w = Split(m, "")
- brr(s, 1) = w(UBound(w))
- w2 = Split(f, "")
- brr(s, 2) = w2(UBound(w2))
- w3 = Split(Cells(1, j).Address, "$$")(1)
- brr(s, 3) = w3
- brr(s, 4) = arr(1, j) & "=" & arr(2, j)
- Exit For
- End If
- Next
- Next
- Next
- Range("a1").Resize(s, 4) = brr
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|