Eric,

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

--
sb
"Eric Dreshfield" wrote in message
...
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 ?