Application.DisplayAlerts = False
ActiveWorkbook.SaveAs (etc.)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Bob Mignault" wrote in message
...
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