Saving an Excel File
 

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

Saving an Excel File
 

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