| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As without overwrite prompt
I want to overwrite an old file without getting prompted as to whether it's
OK. Is there something I can specify on the SaveAs command? Or do I delete the old file first (if it's there)? -- Thanks, Fred Please reply to newsgroup, not e-mail |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save As without overwrite prompt
Hi,
use the application.displayalerts = false thisworbook.save application.displayalerts = true -- Mucho gusto, Cesar Zapata Fred Smith wrote: I want to overwrite an old file without getting prompted as to whether it's OK. Is there something I can specify on the SaveAs command? Or do I delete the old file first (if it's there)? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save As without overwrite prompt
a nitpick, but you shouldn't need that with save for a workbook that has
been previously saved, but as the OP specified SAVEAS application.displayalerts = false thisworbook.saveas . . . application.displayalerts = true -- Regards, Tom Ogilvy "Cesar Zapata" wrote in message ... Hi, use the application.displayalerts = false thisworbook.save application.displayalerts = true -- Mucho gusto, Cesar Zapata Fred Smith wrote: I want to overwrite an old file without getting prompted as to whether it's OK. Is there something I can specify on the SaveAs command? Or do I delete the old file first (if it's there)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save As / Overwrite | Excel Discussion (Misc queries) | |||
| getting rid of copy/overwrite prompt on Save | Excel Discussion (Misc queries) | |||
| save prompt for user exit, but no save prompt for batch import? | Excel Discussion (Misc queries) | |||
| How to save a file without overwrite or save a copy? | Setting up and Configuration of Excel | |||
| Prompt to overwrite | Excel Programming | |||
Linear Mode
