Macro to save workbook to specific folder with a specific name, then kill/disable itself.

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).

jonvanwyk,

Something like this should do it:

Please Login or Register  to view this content.

You're very welcome