M
Mike Knight
From Excel toolbar, A user's current "File Save As" location is
\\Server1\UsersName\Documents.
After my code saves the open workbook (ActiveWorkbook.SaveAs Filename)
to \\Server2\MyName\Documents, the next time the user does "File Save
As" from an Excel toolbar, the location seen is
\\Server2\Myname\Documents.
How can I store the users's current "File Save As" path, run code, and
restore the user's current "File Save As" path?
In other words, the next time the users selects "File Save As", no
directory path changes will be noticed.
Thanks,
Mike
\\Server1\UsersName\Documents.
After my code saves the open workbook (ActiveWorkbook.SaveAs Filename)
to \\Server2\MyName\Documents, the next time the user does "File Save
As" from an Excel toolbar, the location seen is
\\Server2\Myname\Documents.
How can I store the users's current "File Save As" path, run code, and
restore the user's current "File Save As" path?
In other words, the next time the users selects "File Save As", no
directory path changes will be noticed.
Thanks,
Mike