View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Bob is offline
external usenet poster
 
Posts: 972
Default Overriding the overwrite confirmation prompt

Is there a way to modify the line below so that if the file "Project
Status.txt" already exists, it will automatically be overwritten without
prompting the user to confirm the overwrite?

ActiveWorkbook.SaveAs Filename:="Project Status.txt", _
FileFormat:=xlText, CreateBackup:=False

Thanks in advance for any help.

Bob