I would like to create a macro button called "CreateDocument" that
1. Automatically saves the workbook to a specified folder on a shared drive "G:\Shared Folder\"
2. Saves the workbook name based on "F2" - "F1" format where if "F1" is "Doe, John" and F2 is "1234". In this example the the saved document would be "1234 - Doe, John.xlsm"
3. The macro should kill itself after saving the document under the new name to the specified folder (or it should at least disable itself from being used again in the newly created document).
Bookmarks