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.

Hi,

Application.displayalerts=false

your code

application.displayalerts=true

Mike

"Sunil Pradhan" wrote:

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.