Excel2003使用重命名指令ren结合批处理实现批量修改文件名

rem 定义要重命名的文件列表set "filenames="rem 加载要使用的excel宏rem "load excel.exe" 替换为您实际加载宏的命令excel /nogui "C:pathtoexcel.exe"rem 循环遍历文件列表并进行重命名for %%i in ("%CD%*.xls") do (echoRenaming file: "%%i" to "new_name.xls"excel /nogui "C:pathtoexcel.exe" "%%i" "new_name.xls"set "filenames=%%i new_name.xls"rem 添加成功后退出循环if %filenames%=="" (echoAll files have been successfully renamed.pausebreak))