Selecting a response on a dialogue box from a Macro
 

What is the code to select a response on a dialogue box?

I have a Macro which saves the open work book to a couple of locations
- in one of the locations it needs to be saved with the same file name
each time.

Obviously each time the macro runs, Excel opens a dialogue box asking

"Are you sure you want to Save? - this file already exists"

What code can I use to select the Yes button from the Macro?

Cheers,

Steve

Selecting a response on a dialogue box from a Macro
 

Try this.
Near the top of your macro, add the line:
Application.DisplayAlerts = False

then near the end of the macro, add the line:
Application.DisplayAlerts = True

"ChemicalJasper" wrote:

What is the code to select a response on a dialogue box?

I have a Macro which saves the open work book to a couple of locations
- in one of the locations it needs to be saved with the same file name
each time.

Obviously each time the macro runs, Excel opens a dialogue box asking

"Are you sure you want to Save? - this file already exists"

What code can I use to select the Yes button from the Macro?

Cheers,

Steve

Selecting a response on a dialogue box from a Macro
 

Spot on! - Thanks very much!


RCW wrote:
Try this.
Near the top of your macro, add the line:
Application.DisplayAlerts = False

then near the end of the macro, add the line:
Application.DisplayAlerts = True

"ChemicalJasper" wrote:

What is the code to select a response on a dialogue box?

I have a Macro which saves the open work book to a couple of locations
- in one of the locations it needs to be saved with the same file name
each time.

Obviously each time the macro runs, Excel opens a dialogue box asking

"Are you sure you want to Save? - this file already exists"

What code can I use to select the Yes button from the Macro?

Cheers,

Steve