| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do you want to replace existing file?
I have written some code to "Save As..." a specific
workbook, which I will assign to a command button. This procedure will be used frequently and I need no archive of old files. The problem I am having is the Microsoft prompt that asks if I want to replace the existing file. Can someone provide me with the code to always make the answer "Yes" so I no longer receive this prompt? Much appreciated! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Do you want to replace existing file?
try
application.displayalerts=false your code application.displayalerts=true -- Don Guillett SalesAid Software "Tony" wrote in message ... I have written some code to "Save As..." a specific workbook, which I will assign to a command button. This procedure will be used frequently and I need no archive of old files. The problem I am having is the Microsoft prompt that asks if I want to replace the existing file. Can someone provide me with the code to always make the answer "Yes" so I no longer receive this prompt? Much appreciated! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Do you want to replace existing file?
Beautiful! Thanks, Don!
-----Original Message----- try application.displayalerts=false your code application.displayalerts=true -- Don Guillett SalesAid Software "Tony" wrote in message ... I have written some code to "Save As..." a specific workbook, which I will assign to a command button. This procedure will be used frequently and I need no archive of old files. The problem I am having is the Microsoft prompt that asks if I want to replace the existing file. Can someone provide me with the code to always make the answer "Yes" so I no longer receive this prompt? Much appreciated! . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Do you want to replace existing file?
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User replaces existing file with blank during file open | Excel Discussion (Misc queries) | |||
| How do I paste to append instead of replace existing data? | Excel Discussion (Misc queries) | |||
| 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 | |||
Linear Mode
