General discussion
July 23, 2004 at 06:58 AM
sfath

Using SaveAs in Excel Macro

by sfath . Updated 22 years, 2 months ago

I created a macro in excel that saves a file in a certain folder as a certain name. However when I attempt to rerun the macro I am prompted to overwrite the current file (Yes/No Cancel). Is there anyway to eliminate this prompt so the file will automatically be overwritten?

This discussion is locked

All Comments