Save without 'Replace' Prompt

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a command button to exit my user form and save the updated worksheet.

Only problem is this brings up a prompt asking the user if they wish to
replace the existing file.

I currently use the following line of code.

ActiveWorkbook.SaveAs my_folder & "\\HDQ014-FS02\public\Revenue
Accounts\FRAUD DATA\Insurance chargebacks john.xls"

Is there anyway for me to change this so the file saves and overwrites the
exisitng file without the prompt to the user?

Thanks

John
 
Try this

Application.DisplayAlerts = False
'Save code
Application.DisplayAlerts = True
 
Back
Top