Force overwrite when using SaveAs

[shawnpgorman]

I have looked through the forum for an answer to this but I could not find one. Is there a way to use SaveAs without having to select Yes to overwrite files that already exist?

Revise: I figured a way around the problem by detecting and deleting a file by the name of the file you are trying to save.

Code:

Please Login or Register  to view this content.

[raypayette]

That's the difference between Save and Save as.
Use: ActiveWorkbook.Save

[mudraker]

before the save command use

Please Login or Register  to view this content.

after the save command use

Please Login or Register  to view this content.