How do I avoid the message?

  • Thread starter Thread starter Jeff Wright
  • Start date Start date
J

Jeff Wright

I have a macro which (among other tasks) saves the existing open file to
"temp.xls". However, I want to avoid the dialogue box which says "File
exists . . . do you want to replace?" Is there a line I can put into my
macro which will save the file to "temp.xls" without asking me whether or
not I want to overwrite the existing file?

Thanks,


John Berry
 
Application.DisplayAlerts = False

save your workbook

Application.DisplayAlerts = tru
 
Back
Top