Hello,
I'm need a macro to do the following upon hitting a command button on the sheet:
1) Move the sheet to a new workbook, but do not carry over macro button or code
2) Save the new workbook as the name of the sheet (Example: if sheet name was "Sheet1", then new workbook would be saved as "Sheet1.xls") to C:\Folder1
3) Close the new workbook after it's been saved
I would also like a macro that will do the same thing as mentioned above, but instead of using the sheet name as the save as name, I would like the macro to save the new workbook as the sheet name and todays date + 1. Example: If the sheet was named "Schedule" and today was 8/22/2012, I would like it to save the new workbook as "Schedule 082312.xls".
Thanks for your help!
Bookmarks