S
Susie
I have several macros that I run daily. I have reports
that are replaced daily and uploaded to our intranet
site. So when I run the macro, I am prompted each time as
to whether I want to replace the file. I had previously
used your forum and asked how I could get the pop-ups to
quit. I was told to use the SetWarnings actions and set
the argument to no. I put this action on the first row of
the macro. But I am still getting the prompts. I see in
the description for this action it says that dialogs that
require user input still appear. So I'm assuming this is
the case for me. But I just wanted to cover all my
bases. I have macros that run for 2-2 1/2 hours and it
gets very cumbersome to click OK for that long. Is there
something I am doing wrong, or is there another option to
get rid of the dialog boxes. Thank you in advance for
your help.
Susie
that are replaced daily and uploaded to our intranet
site. So when I run the macro, I am prompted each time as
to whether I want to replace the file. I had previously
used your forum and asked how I could get the pop-ups to
quit. I was told to use the SetWarnings actions and set
the argument to no. I put this action on the first row of
the macro. But I am still getting the prompts. I see in
the description for this action it says that dialogs that
require user input still appear. So I'm assuming this is
the case for me. But I just wanted to cover all my
bases. I have macros that run for 2-2 1/2 hours and it
gets very cumbersome to click OK for that long. Is there
something I am doing wrong, or is there another option to
get rid of the dialog boxes. Thank you in advance for
your help.
Susie