Saving a file in a macro

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 ?
 
S

steve

Eric,

Use
Application.DisplayAlerts = False
*your code*
Application.DisplayAlerts = True
 
Top