I put together a userform that saves a copy of a file while keeping the
file open. I create the filepath for this archive copy by getting user
inputs fromt the form. I want to display the full filepath of the
archive workbook in another userform after the user pushes the save
button in my first user form.
How do I get the filepath (a merged string of information) to show up
in this second user form textbox without changing the source.
The file path is in sheet2, c1