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!