Saving a file in a macro

  • Thread starter Thread starter Eric Dreshfield
  • Start date Start date
E

Eric Dreshfield

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 ?
 
Back
Top