| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
within a macro how can I suppress the warning pop "A file named xxxx.xls already exists in this location. Do you want to replace it?"
Kevin,
Application.displayalerts=false Activeworkbook.saveas filename:="C:\SameName.xls" Application.displayalerts=true -----Original Message----- Within a macro how can I suppress/omit the warning pop "A file named xxxx.xls already exists in this location. Do you want to replace it?" Thanks in advance. Sincerely, Kevin Waite |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why doesn't "Replace" function find value I know exists? | Excel Worksheet Functions | |||
| "the file already exsists in this location do you want to replace. | Excel Discussion (Misc queries) | |||
| Why Am I Getting the "Named Argument Not Found" Warning? | Excel Discussion (Misc queries) | |||
| Subtotal without "xxxx total" but only xxxx | Excel Discussion (Misc queries) | |||
| How do you replace an existing file, saying "yes" in a macro? | Excel Programming | |||
Linear Mode
