I have searched the forum, but I cannot find an example of prompting without a filename hardcoded in the VBA.
I tried recording the macro and copying the code, but it made me save to a location before it would allow me to stop the recorder.
How would I prompt to Save As and allow the user to save to the location of their liking?
I feel silly for asking, but this has got me stumped.
Thanks!
I tried recording the macro and copying the code, but it made me save to a location before it would allow me to stop the recorder.
How would I prompt to Save As and allow the user to save to the location of their liking?
I feel silly for asking, but this has got me stumped.
Thanks!