Override save as Dialog box
 

I have a macro that creates a files called member.xls and sticks it on my
desktop. When it saves the file, a dialog box appears and asks me if I want
to replace the file that already exists.

How do I keep this dialog box from coming up since I always want to replace
the file on the desktop for the newer version that I just created?

Thanks.

Override save as Dialog box
 

application.displayalerts=false
'your code to save
application.displayalerts = true



Raza wrote:

I have a macro that creates a files called member.xls and sticks it on my
desktop. When it saves the file, a dialog box appears and asks me if I want
to replace the file that already exists.

How do I keep this dialog box from coming up since I always want to replace
the file on the desktop for the newer version that I just created?

Thanks.

--

Dave Peterson

Override save as Dialog box
 

Thanks, that worked great!

"Dave Peterson" wrote:

application.displayalerts=false
'your code to save
application.displayalerts = true



Raza wrote:

I have a macro that creates a files called member.xls and sticks it on my
desktop. When it saves the file, a dialog box appears and asks me if I want
to replace the file that already exists.

How do I keep this dialog box from coming up since I always want to replace
the file on the desktop for the newer version that I just created?

Thanks.

--

Dave Peterson