|
参与一下。。。
- Sub ykcbf() '//2024.6.10
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- Set d = CreateObject("Scripting.Dictionary")
- p = ThisWorkbook.Path
- Set sh = ThisWorkbook.Sheets("Sheet1")
- sh.[a:d] = ""
- ReDim zrr(1 To 10000, 1 To 5)
- f1 = p & "\1.xlsb"
- f2 = p & "\2.xlsb"
- Set wb1 = Workbooks.Open(f1, 0)
- Set wb2 = Workbooks.Open(f2, 0)
- For Each sht1 In wb1.Sheets
- d.RemoveAll
- With sht1
- r = .Cells(Rows.Count, 1).End(3).Row
- arr = .[a1].Resize(r, 3)
- fn1 = .Name
- End With
- For i = 1 To UBound(arr)
- s = arr(i, 1)
- d(s) = i
- Next
- With wb2.Sheets(fn1)
- r = .Cells(Rows.Count, 1).End(3).Row
- brr = .[a1].Resize(r, 3)
- For i = 1 To UBound(brr)
- s = brr(i, 1)
- If d.exists(s) Then
- m = m + 1
- zrr(m, 1) = arr(d(s), 1)
- zrr(m, 2) = arr(d(s), 2)
- zrr(m, 3) = arr(d(s), 3)
- zrr(m, 4) = fn1
- zrr(m, 5) = wb1.Name
- m = m + 1
- zrr(m, 1) = brr(i, 1)
- zrr(m, 2) = brr(i, 2)
- zrr(m, 3) = brr(i, 3)
- zrr(m, 4) = .Name
- zrr(m, 5) = wb2.Name
- End If
- Next
- End With
- Next
- wb1.Close False
- wb2.Close False
- sh.[a1].Resize(m, 5) = zrr
- Set d = Nothing
- Application.ScreenUpdating = True
- Application.DisplayAlerts = True
- MsgBox "OK!"
- End Sub
复制代码
|
|