within a macro how can I suppress the warning pop "A file named xxxx.xls already exists in this loca

P

Pete McCosh

Kevin,

Application.displayalerts=false

Activeworkbook.saveas filename:="C:\SameName.xls"

Application.displayalerts=true
-----Original Message-----
Within a macro how can I suppress/omit the warning pop "A
Click to expand...
file named xxxx.xls already exists in this location. Do
you want to replace it?"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Save As problem with file that already exist 2
How do I suppress user dialog in File Save As? 1
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
How to stop error messages from showing 2
VBA Save As problem with file that already exist 3
Pop up Windows Question 6
File Save Macro "End If" Problems . . . 6
Addin Install 4

Top