How do I avoid the message?

[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

 

[mudraker]

Application.DisplayAlerts = False

save your workbook

Application.DisplayAlerts = tru

 

[Dave Hawley]

Hi John

Application.DisplayAlerts=False
'YOUR CODE
Application.DisplayAlerts=True

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Jeff Wright]

Thanks for your help!!!

John

 

[Jeff Wright]

Thanks much for your help!!!

John