Save without 'Replace' Prompt

[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

 

[Ron de Bruin]

Try this

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