| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run Excel macro from Scheduled Task | Excel Worksheet Functions | |||
| Trying to run a MSQuery from Excel as a Scheduled Task | Excel Discussion (Misc queries) | |||
| Running an Excel Macro as a Scheduled Task | Excel Programming | |||
| Scheduled task hanging | Excel Programming | |||
| Scheduled Task | Excel Programming | |||
Linear Mode
