View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ed[_9_] Ed[_9_] is offline
external usenet poster
 
Posts: 194
Default "Go ahead and replace file" command?

I need to create a file and SaveAs a file with the same name. Will the
Alerts = False automatically tell it "Yes, replace the other file with the
same name"? Or is there another line I should add to the SaveAs code to
tell Excel to overwrite and replace the existing file?

Thanks.
Ed