within a macro how can I suppress the warning pop "A file named xxxx.xls already exists in this location. Do you want to replace it?"
Kevin,
Application.displayalerts=false
Activeworkbook.saveas filename:="C:\SameName.xls"
Application.displayalerts=true
-----Original Message-----
Within a macro how can I suppress/omit the warning pop "A
file named xxxx.xls already exists in this location. Do
you want to replace it?"
Thanks in advance.
Sincerely,
Kevin Waite
|