| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
When Wanting To Replace Previously Saved .xls File
Is there any way to do this in VBA code so that the user is not prompte with the 'Replace?' Question? Thanks for a response, Chuckles12 -- Chuckles12 ----------------------------------------------------------------------- Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494 View this thread: http://www.excelforum.com/showthread.php?threadid=27725 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
When Wanting To Replace Previously Saved .xls File
Hi Chuckles123,
Is there any way to do this in VBA code so that the user is not prompted with the 'Replace?' Question? Yes, put: Application.DisplayAlerts = False before the Save As, and Application.DisplayAlerts = True after it. Regards Stephen Bullen Microsoft MVP - Excel www.oaltd.co.uk |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unsave or get a previously saved file - HELP PLEASE! | Excel Discussion (Misc queries) | |||
| How do i revert to a previously saved excel file? SOS!!! | Excel Discussion (Misc queries) | |||
| IS THERE ANYWAY TO RETRIEVE A PREVIOUSLY SAVED FILE ONCE IT HAS B. | Excel Discussion (Misc queries) | |||
| How do I get Excel to open a previously saved file? | Excel Discussion (Misc queries) | |||
| Read only error messagfe on file that was previously saved and ope | Excel Discussion (Misc queries) | |||
![Chuckles123[_47_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
