Do you want to replace existing file?

T

Tony

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!
 
T

Tony

Beautiful! Thanks, Don!
-----Original Message-----
try
application.displayalerts=false
your code
application.displayalerts=true

--
Don Guillett
SalesAid Software
(e-mail address removed)



.
Click to expand...
 

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

Replace Existing File 5
File already exists. Do I want to replace? 2
Replace file without being prompted to save 2
Replace an Existing File 2
Save without 'Replace' Prompt 1
Saveas where file already exists 4
if workbooks exists delete 4
suppressing "do you want to save changes..." 5

Top