| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace Existing File
I am using the following code to save the active workbook:
ActiveWorkbook.SaveAs Filename:="C:\MyWorkbooks\TempFile.xls" How can I get it to select Yes if prompted to Replace the Existing File? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SaveAs macro: How do I specify "Replace existing file?" | Excel Programming | |||
| Do you want to replace existing file? | Excel Programming | |||
| the file already exists - do you want to replace the existing file? | Excel Programming | |||
| How do you replace an existing file, saying "yes" in a macro? | Excel Programming | |||
| Automatically replace existing file on save | Excel Programming | |||
Threaded Mode
