File save as

[Sunil Pradhan]

I have written a macro to save file in certain location using save as command.

Sometime destination already has the filename i use while using save as
command within the macro due to which it is asking me to overwrite the file.

What should i do to stop pop up of overwriting confirmation of file.

 

[Mike H]

Hi,

Application.displayalerts=false

your code

application.displayalerts=true

Mike