Saving a file in a macro

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

 

[steve]

Eric,

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

 

[Eric Dreshfield]

Steve,

Thanks !!

Eric

-----Original Message-----
Eric,

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

--
sb



.