Saving an Excel File

[Bob Mignault]

I use "ActiveWorkbook.Save" to save the Excel worksheet as I exit the
program.

In code, how can I prevent the system from advising that the file already
exists and asking if I want to replace the existing file?

Regards,

Bob Mignault

 

[Bernard Liengme]

Application.DisplayAlerts = False
ActiveWorkbook.SaveAs (etc.)

best wishes