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 ?

Saving a file in a macro
 

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 ?

Saving a file in a macro
 

Steve,

Thanks !!

Eric
-----Original Message-----
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 ?


.