| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Say 'YES' to overwrite file
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:=fsn Application.DisplayAlerts = True -- Regards, Tom Ogilvy "Mike G." wrote in message ... Dear Guru's and Experts: I'm sure this is a simple one for you. I want my script to automatically reply "YES" when prompted if I wish to overwrite a file. My existing coding is ... 'Save the file ActiveWorkbook.SaveAs Filename:=fsn Your guidance and help is appreciated and gives me more knowledge. Best regards, Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel File Overwrite | Excel Discussion (Misc queries) | |||
| accidental file overwrite | Excel Discussion (Misc queries) | |||
| VBA to automatically test for file, update, overwrite | Excel Discussion (Misc queries) | |||
| retrieving of overwrite excel file? | Excel Discussion (Misc queries) | |||
| how to overwrite a write reserved file? | Excel Programming | |||
Threaded Mode
