Scheduled Task Saving from a Macro

[Guest]

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?

 

[Guest]

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