| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Allow a macro to save over another file
I've written a macro which saves a file with a pre existing name, how can I
make the macro say Yes to overwrite the file that already exists? Any help gratefully received. Thanks in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Allow a macro to save over another file
Application.DisplayAlerts = False
turn back on if doing anything else -- -- -John Please rate when your question is answered to help us and others know what is helpful. "Marie Bayes" wrote in message ... I've written a macro which saves a file with a pre existing name, how can I make the macro say Yes to overwrite the file that already exists? Any help gratefully received. Thanks in advance. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Allow a macro to save over another file
Sandwich the code in
Application.DisplayAlerts = False 'Your code here Application.DisplayAlerts = True Regards, Alan. "Marie Bayes" wrote in message ... I've written a macro which saves a file with a pre existing name, how can I make the macro say Yes to overwrite the file that already exists? Any help gratefully received. Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to save file in a macro taking new name from cell contents? | Excel Discussion (Misc queries) | |||
| Macro to auto save file using the format YYMM | Excel Discussion (Misc queries) | |||
| Macro to save a file as | Excel Discussion (Misc queries) | |||
| How to stop getting the file save box when running a macro | Excel Discussion (Misc queries) | |||
| This one is tricky....Macro to save file as cell value x in di | Excel Discussion (Misc queries) | |||
Hybrid Mode
