Scheduled Task Saving from a Macro
 

Hi All!

Here's my problem, I have a scheduled task set up to run a macro in Excel
every morning, and then post the revised sheet to a server. Right now,
evertime the program runs, it Excel asks if I want to replace the file that
already exists at the location. Is there anyway I can get Excel to not ask
me the question, or automatically answer the question for itself, so my
scheduled task does not hang until an answer is given?

--
Thanks!
Max

Scheduled Task Saving from a Macro
 

i thnk I found the answer on another thread:

Application.DisplayAlerts = False 'Put at begining of code

Application.DisplayAlerts = True 'Put at end of code
--
Thanks!
Max


"Max" wrote:

Hi All!

Here's my problem, I have a scheduled task set up to run a macro in Excel
every morning, and then post the revised sheet to a server. Right now,
evertime the program runs, it Excel asks if I want to replace the file that
already exists at the location. Is there anyway I can get Excel to not ask
me the question, or automatically answer the question for itself, so my
scheduled task does not hang until an answer is given?

--
Thanks!
Max