I'm trying to create a VBA code to copy the active sheet to a new book but I want to rename the new book after the sheet name. Then I'm going to email it.
I have a lot of these to do.
I have this code, but can't work out how to rename the book.
' Copy Macro