|
- Sub lqxs()
- Dim Arr, myPath$, myName$, wb As Workbook, sh As Worksheet
- Dim funm$, i&, d(2), nm, m&
- Application.ScreenUpdating = False
- For i = 0 To 2
- Set d(i) = CreateObject("Scripting.Dictionary")
- Next
- Set wb = ThisWorkbook
- funm = "汇总.xlsm"
- nm = Array("大班", "中班", "小班")
- myPath = ThisWorkbook.Path & ""
- myName = Dir(myPath & "*.xlsx")
- Do While myName <> "" And myName <> funm
- With GetObject(myPath & myName)
- For Each sh In .Sheets
- Arr = sh.Range("b5").CurrentRegion
- m = Application.Match(sh.Name, nm, 0) - 1
- For i = 1 To UBound(Arr)
- d(m)(Arr(i, 1)) = ""
- Next
- Next
- .Close False
- End With
- myName = Dir
- Loop
- For i = 0 To 2
- Sheets(nm(i)).[b5].Resize(100, 1).ClearContents
- Sheets(nm(i)).[b5].Resize(d(i).Count, 1) = Application.Transpose(d(i).keys)
- Next
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|