My macro saves a workbook and overwrites an existing one. How can I stop the macro from asking if I want to replace the existing one?
Application.DisplayAlerts = false does not help, as the default answer is 'no' and doesn't overwrite the workbook.
What can I do?
Thanks.
Bookmarks