|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
Sub gj23w98()
Dim brr(1 To 99999, 1 To 4)
Application.ScreenUpdating = False
p = ThisWorkbook.Path & "\分表\"
f = Dir(p & "*.xls*")
Do While Len(f)
If f <> ThisWorkbook.Name Then
Set wb = Workbooks.Open(p & f)
With wb.Sheets("销售")
arr = .[a1].CurrentRegion
For i = 2 To UBound(arr)
m = m + 1
brr(m, 1) = Split(wb.Name, ".")(0)
For j = 2 To 4
brr(m, j) = arr(i, j)
Next
Next
End With
wb.Close False
End If
f = Dir
Loop
If m Then
[a10].CurrentRegion.Offset(1).Clear
[a11].Resize(m, 4) = brr
[a11].Resize(m, 4).Borders.LineStyle = 1
End If
Application.ScreenUpdating = True
End Sub |
评分
-
1
查看全部评分
-
|