ExcelBanter - Method SaveAs with no overwrite YesNoCancel dialog

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Method SaveAs with no overwrite YesNoCancel dialog (https://www.excelbanter.com/excel-programming/304298-method-saveas-no-overwrite-yesnocancel-dialog.html)

Peter Pham

Method SaveAs with no overwrite YesNoCancel dialog

How do I use the SaveAs method and suppress the overwrite YesNoCancel
dialog when the same file already exists?
Is there any other way to achieve this?
thanks
Peter

Bob Umlas[_2_]

Method SaveAs with no overwrite YesNoCancel dialog

Before the SaveAs, enter:
Application.DisplayAlerts = False

Bob Umlas
Excel MVP

-----Original Message-----
How do I use the SaveAs method and suppress the overwrite
YesNoCancel
dialog when the same file already exists?
Is there any other way to achieve this?
thanks
Peter
.

All times are GMT +1. The time now is 07:53 PM.