Hello all,
I need to create a new worksheet (new file) based on a sheet.
I do that using the below code
That it will create a new file with the sheet's contents.
What I need is to rename the newly created file based on a sheet name. I think I have to do that before create the new sheet.
Is this possible?
Thank you
I need to create a new worksheet (new file) based on a sheet.
I do that using the below code
VBA Code:
Sheets("NewSheet").Copy
That it will create a new file with the sheet's contents.
What I need is to rename the newly created file based on a sheet name. I think I have to do that before create the new sheet.
Is this possible?
Thank you