View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eric Dreshfield Eric Dreshfield is offline
external usenet poster
 
Posts: 14
Default Saving a file in a macro

I am using the following statement to save a file:

ActiveSheet.SaveAs FileName:="c:\imports\paycheck.CSV",
FileFormat:=xlCSV, CreateBackup:=False


If the file already exists I get prompted with the
overwrite box...can I do something in the macro to
automatically overwrite the existing file ?