|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
本帖最后由 ykcbf1100 于 2024-6-4 09:07 编辑
遍历文件夹,文件夹和文件改名- Sub ykcbf() '//2024.6.4 文件和文件夹改名
-
- Set fso = CreateObject("scripting.filesystemobject")
- Application.ScreenUpdating = False
- p = ThisWorkbook.Path & ""
- b = [{"1-", "第一批次-"}]
- For Each f In fso.GetFolder(p).Files
- If InStr(f.Name, "1-") Then
- f.Name = Replace(f.Name, b(1), b(2))
- End If
- Next f
- Set ff = fso.GetFolder(p)
- getfd ff
- Application.ScreenUpdating = True
- MsgBox "OK!"
- End Sub
- Sub getfd(ff)
- b = [{"1-", "第一批次-"}]
- For Each fd In ff.SubFolders
- For Each f In fd.Files
- If InStr(f.Name, "1-") Then
- f.Name = Replace(f.Name, b(1), b(2))
- End If
- Next
- If InStr(1, fd.Name, "1-") > 0 Then
- fd.Name = Replace(fd.Name, b(1), b(2))
- End If
- getfd fd
- Next fd
- End Sub
复制代码
|
评分
-
1
查看全部评分
-
|