| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically replace existing file on save
VBA code:
I want to replace an existing file with a file of the same name in the same directory. I want to do so bypassing the warning message box. How can I do that? TIA Ron ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Automatically replace existing file on save
Ron
Application.DisplayAlerts = False ' Your code ... Application.DisplayAlerts = True Regards Trevor "ronber" wrote in message ... VBA code: I want to replace an existing file with a file of the same name in the same directory. I want to do so bypassing the warning message box. How can I do that? TIA Ron ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I save a file of multiple names to replace using excell 03 | Excel Discussion (Misc queries) | |||
| Can I automatically replace data when importing a text file? | New Users to Excel | |||
| Disable Dialogue Box To Save & Replace File | Excel Discussion (Misc queries) | |||
| Existing file not defaulting to same location using "Save As" | Excel Discussion (Misc queries) | |||
| can i save an existing .xls file as a .csv file using command line | Excel Discussion (Misc queries) | |||
![ronber[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
