Automatically Answer YES for Pop Up Msg Box

[Holger Friebe]

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

 

[Frank Kabel]

Hi
put the line
application.displayalerts = False
before your save codeand
application.displayalerts = True
after this saving code

 

[Holger Friebe]

Hello Frank,

thank you for your fast answer.

Hi
put the line
application.displayalerts = False
before your save code and
application.displayalerts = True
after this saving code

I tried your proposal before to do what I state above. The trouble is that
due to the fact that the default is set to continue with NO the intended
overwriting of the file does not happen! Therefore I have to not only find a
way to hide the display as your code definitely does but also to change the
default answer before the code continues on.

Thank you for your help.

Holger