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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replace file without being prompted to save 2
save existing file name, different format. 4
save as - location or default 3
How To Exit Macro Without Debug Prompting 4
how to close Read Only file without prompt to save copy 3
Overriding the overwrite confirmation prompt 2
Close all without saving and exit without prompts 8
Prompt for Save Path - Use Cell Content for File Name 1

Back
Top