I want VBA to "save as" and replace an existing file.
When I record the macro, I go through the steps including
clicking "yes" when asked if I want to replace the
existing file with the one being saved. But that step
doesn't show up in the code. Can someone provide a
sample code to answer "yes" when asked if I want to
replace the file?
Thanks.