Saving a File to a Name That Already Exists

[Mike H.]

I want to overwrite a file that already exists with the saving of a file
using VBA but I do NOT want the user to have to see the dialog box that warns
of this issue. I wish the save to be automatic. I thought it might have to
do with the ConflictResolution parameter of the save but can't determine how
to set it. How do I avoid the user being prompted to confirm saving over a
file that exits. Or would it be easier to delete the file before saving. If
so how do I delete it first?

 

[Mike H]

Try:-

Application.displayalerts=false
Your save command
Application.displayalerts=true

Mike