| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel SaveAs to force overwrite of extant file
I'm using Excel 2007 in 2003 compatibility mode. I have a VBA macro that
saves a dynamic file name using SaveAs, but the file name may or may not already exist. I wish to force the SaveAs command to overwrite any pre-existing file automatically (without user intervention to confirm that I wish to overwrite the extant file). I'm sure I could do this in Excel 2003 but can I do it in Excel 2007 and in compatibility mode? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel SaveAs to force overwrite of extant file
Wrap your code in
Application.DisplayAlerts = False your save code Application.DisplayAlerts = True Gord Dibben MS Excel MVP On Fri, 12 Feb 2010 11:52:01 -0800, Bill Armitage wrote: I'm using Excel 2007 in 2003 compatibility mode. I have a VBA macro that saves a dynamic file name using SaveAs, but the file name may or may not already exist. I wish to force the SaveAs command to overwrite any pre-existing file automatically (without user intervention to confirm that I wish to overwrite the extant file). I'm sure I could do this in Excel 2003 but can I do it in Excel 2007 and in compatibility mode? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SaveAs and always overwrite? | Excel Programming | |||
| Q: overwrite during saveas | Excel Discussion (Misc queries) | |||
| Method SaveAs with no overwrite YesNoCancel dialog | Excel Programming | |||
| Using SaveAs Statement to overwrite existing File | Excel Programming | |||
| overwrite Excel SaveAs function from File menu | Excel Programming | |||
Linear Mode
