View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default 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