Saving
 

Is there a way to save so that is automatically replaces
an existing file, without asking the user?

This is what I am currently using:

ActiveWorkbook.SaveAs Filename:="C:\Dir\filename.xls", _
FileFormat:=xlNormal, Password:="",
WriteResPassword:="", _ReadOnlyRecommended:=False,
CreateBackup:=False

ActiveWorkbook.SaveAs Filename:="C:\Dir\filename.csv",
FileFormat _:=xlCSV, CreateBackup:=False

Thanks for your help.

Saving
 

Hi
try:
application.displayalerts=false
'saving code
application.displayalerts=true

--
Regards
Frank Kabel
Frankfurt, Germany

"Cindy" schrieb im Newsbeitrag
...
Is there a way to save so that is automatically replaces
an existing file, without asking the user?

This is what I am currently using:

ActiveWorkbook.SaveAs Filename:="C:\Dir\filename.xls", _
FileFormat:=xlNormal, Password:="",
WriteResPassword:="", _ReadOnlyRecommended:=False,
CreateBackup:=False

ActiveWorkbook.SaveAs Filename:="C:\Dir\filename.csv",
FileFormat _:=xlCSV, CreateBackup:=False

Thanks for your help.

Saving
 

Thank you so much, it worked perfect.
-----Original Message-----
Hi
try:
application.displayalerts=false
'saving code
application.displayalerts=true

--
Regards
Frank Kabel
Frankfurt, Germany

"Cindy" schrieb im
Newsbeitrag
...
Is there a way to save so that is automatically
replaces
an existing file, without asking the user?

This is what I am currently using:

ActiveWorkbook.SaveAs Filename:="C:\Dir\filename.xls",
_
FileFormat:=xlNormal, Password:="",
WriteResPassword:="", _ReadOnlyRecommended:=False,
CreateBackup:=False

ActiveWorkbook.SaveAs Filename:="C:\Dir\filename.csv",
FileFormat _:=xlCSV, CreateBackup:=False

Thanks for your help.

.