Do you want to replace existing file?
 

I have written some code to "Save As..." a specific
workbook, which I will assign to a command button. This
procedure will be used frequently and I need no archive
of old files. The problem I am having is the Microsoft
prompt that asks if I want to replace the existing file.
Can someone provide me with the code to always make the
answer "Yes" so I no longer receive this prompt?

Much appreciated!

Do you want to replace existing file?
 

try
application.displayalerts=false
your code
application.displayalerts=true

--
Don Guillett
SalesAid Software

"Tony" wrote in message
...
I have written some code to "Save As..." a specific
workbook, which I will assign to a command button. This
procedure will be used frequently and I need no archive
of old files. The problem I am having is the Microsoft
prompt that asks if I want to replace the existing file.
Can someone provide me with the code to always make the
answer "Yes" so I no longer receive this prompt?

Much appreciated!

Do you want to replace existing file?
 

Beautiful! Thanks, Don!

-----Original Message-----
try
application.displayalerts=false
your code
application.displayalerts=true

--
Don Guillett
SalesAid Software

"Tony" wrote in
message
...
I have written some code to "Save As..." a specific
workbook, which I will assign to a command button.
This
procedure will be used frequently and I need no archive
of old files. The problem I am having is the Microsoft
prompt that asks if I want to replace the existing
file.
Can someone provide me with the code to always make the
answer "Yes" so I no longer receive this prompt?

Much appreciated!


.

Do you want to replace existing file?
 

glad to help

--
Don Guillett
SalesAid Software

"Tony" wrote in message
...
Beautiful! Thanks, Don!

-----Original Message-----
try
application.displayalerts=false
your code
application.displayalerts=true

--
Don Guillett
SalesAid Software

"Tony" wrote in
message
...
I have written some code to "Save As..." a specific
workbook, which I will assign to a command button.
This
procedure will be used frequently and I need no archive
of old files. The problem I am having is the Microsoft
prompt that asks if I want to replace the existing
file.
Can someone provide me with the code to always make the
answer "Yes" so I no longer receive this prompt?

Much appreciated!


.