I have a macro that creates a new workbook. I need to save this new workbook in a specific folder, and change the name to a name that appears in a specific cell in the original workbook. I cant get the name of the new workbook to change from "Book1". Is this possible?
Thanks
Douglas