VBA interactive commands

B

bill

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.
 

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

Top