| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Overwrite option when saving a workbook
Upon closing a new workbook, Is there a way to overwrite any other workbook of the same name in the given folder, without halting the macro to ask the user? wbkR.Close SaveChanges:=True, Filename:= "Spreads.xls" Rgds, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Overwrite option when saving a workbook
Bharath,
I think its... Application.DisplayAlerts = False 'your code Application.DisplayAlerts = true HTH Duncan Bharath Rajamani wrote: Upon closing a new workbook, Is there a way to overwrite any other workbook of the same name in the given folder, without halting the macro to ask the user? wbkR.Close SaveChanges:=True, Filename:= "Spreads.xls" Rgds, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving an Excel file & overwrite (C++) | Excel Programming | |||
| Overwrite Changes when saving | Charts and Charting in Excel | |||
| Calc status of open excel workbook should not overwrite another | Setting up and Configuration of Excel | |||
| want to overwrite Excel workbook instead of appending new data | Excel Discussion (Misc queries) | |||
| Saving to network drive gives unwanted copy or overwrite message | Excel Discussion (Misc queries) | |||
Linear Mode
