Excel VBA Save As

When the user clicks “Yes” how would I invoke a “Save As”. Just like if they were to do that manually. The info they enter is there responsibility. I just want to be able to invoke “Save As”. Just as if you would click the “File” tab and then “Save As”.

Please see the attaches word file for a clearer picture.
Who is Participating?
CompProbSolvConnect With a Mentor Commented:
I believe that what you need to use is

This might help:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.