View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pete McCOsh Pete McCOsh is offline
external usenet poster
 
Posts: 64
Default 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