View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Saving a File to a Name That Already Exists

Try:-

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

Mike

"Mike H." wrote:

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?