Pop up message control using macros

[Pete Davis]

Hi All

Is it possible to respond to pop up messages with a
macro? Im trying to respond to the two following pop ups,
which are generated by activities carried out by the
macro:

1. File already exists. Replace? Yes or No? (Im using the
macro to save an updated version of an existing file). In
this case, I would like the macro to respond with a YES>
2. Large amount of data exists on clipboard. Do you want
data to be available.......Yes or No? (Im using the macro
to close a file which ive copied a large amount of data
from.) In this case, I would like the macro to respond
with a NO.

In Macro Record mode, I responded to each message, but no
code of anykind was copied into the macro.

I dont want the user to be inconvenienced with having to
respond to these messages.

Thanks for any advice.

Pete

 

[Jesse Hamilton]

Try adding:

Application.DisplayAlerts = False

Above your code. This will make it just overwrite without asking unless the
target file is read only.

I'm not sure but that might cause the second one to not show as well.

Jesse Hamilton

 

[Pete]

Beautiful, Jesse. Worked like a charm!! Thanks for the
quick post.

Pete