How do I avoid the message?

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
 
M

mudraker

Application.DisplayAlerts = False

save your workbook

Application.DisplayAlerts = tru
 
Top