951| 2
|
[已解决]请教:文件夹中所有工作薄同时执行宏问题 |
3学分
最佳答案Sub 获取当前文件夹文件()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Set MyFile = CreateObject("Scripting.FileSystemObject")
For Each f In MyFile.GetFolder(ActiveWorkbook.path).Files '.subfolders:子文件夹
If InStr(f.Name, ActiveWorkbook.Name) = 0 And InStr(f.Name, ".xls") Then
Set Wb = Workbooks.Open(f)
With Wb
...
| ||
发表于 2022-8-22 15:35
|
显示全部楼层
本楼为最佳答案
| ||
发表于 2022-8-23 19:18
|
显示全部楼层
| ||