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.