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