6384| 2
|
[已解决]多个xlsx文件批量计算移动平均 |
3学分
最佳答案Sub demo()
Application.ScreenUpdating = False
Set fso = CreateObject("Scripting.FileSystemObject")
For Each file In fso.GetFolder(ThisWorkbook.Path).Files
If Not file Like "*.xlsx" Then GoTo 1
Set wb = Workbooks.Open(file)
For i = 5 To .End(4).Row
Cells(i, 3) = "=average(r[-4]c[-1]:rc[-1])"
Next
wb.Close 1
1:
Next
MsgBox "ok"
End S ...
| ||
发表于 2021-6-20 17:46
|
显示全部楼层
本楼为最佳答案
评分 | ||
评分 | ||