|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
Sub gj23w98()
Dim brr(1 To 10000, 1 To 22)
p = ThisWorkbook.Path
f = Dir(p & "\*.xlsx")
Application.ScreenUpdating = False
Do While f <> ""
If f <> ThisWorkbook.Name Then
With GetObject(p & "\" & f)
With .Sheets("sheet1")
arr = .[a1].CurrentRegion
For i = 2 To UBound(arr)
If arr(i, 15) <> "" Or arr(i, 22) <> "" Then
m = m + 1
For j = 1 To 22
brr(m, j) = arr(i, j)
Next
End If
Next
End With
.Close False
End With
End If
f = Dir()
Loop
With ActiveSheet
.[a2].Resize(m, 22) = brr
End With
Application.ScreenUpdating = True
MsgBox "汇总完成,请查看!"
End Sub |
评分
-
1
查看全部评分
-
|