ExcelBanter - Bypass Replace File

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

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

- - Bypass Replace File (https://www.excelbanter.com/excel-programming/307620-bypass-replace-file.html)

Jon M.[_2_]

Bypass Replace File

I have a "save macro" that is designed to "Save-As". How
do I bypass the "A file already exsists... Do you want to
replace it" question without manually operation? I have
thought about "displayalerts" but it looks like the
defult is no, so that won't help.

Any Ideas?
Thanks

Chip Pearson

Bypass Replace File

Jon,

You can use DisplayAlerts = False in this case, and the file will
be overwritten.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Jon M." wrote in message
...
I have a "save macro" that is designed to "Save-As". How
do I bypass the "A file already exsists... Do you want to
replace it" question without manually operation? I have
thought about "displayalerts" but it looks like the
defult is no, so that won't help.

Any Ideas?
Thanks

All times are GMT +1. The time now is 12:09 PM.