I have recorded a macro to do a “save as” and write over the previous files. After each “save as” excel prompts me to answer “yes” or “no” to overwrite the previous file. I don’t want to keep hitting yes every time so my question is, is there a way to make excel automatically overwrite the files without giving me the prompt?
Here is part of the macro (file name and path altered for security)
ActiveWorkbook.SaveAs Filename:= _
"G:\FOLDER\SUBFOLDER1\SUBFOLDER2\SUBFOLDER3\Excel file Name.xls", _
FileFormat:=xlExcel8, Password:="", WriteResPassword:="", _