Hello,.

by default I would like to program my excel application so that it
automatically overwrite an existing file w/o asking a question if I want to
overwrite that existing file.

In other words:
In my code it says:

ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\Holger Friebe\My Documents\My
Work\Performancebiz.xls" _
, FileFormat:=xlExcel9795, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False,
ConflictResolution:=xlLocalSessionChanges
Workbooks("Performancebiz.xls").Close SaveChanges:=False

This code triggers a message box which basically asks me if I want to
overwrite the existing file.
The default is set to NO.

I would like to
- not to the program ask me that message box question (I found a way how to
do that) and
- to then answer the question as a default with YES.

How can I program this to set to make the program automatically answer YES
and therefore automatically overwrite the existing file?

Thank you for your help.

Holger