#1
|
|||
|
|||
Save each worksheet as new workbook with the sheetname=workbookname
I ave found several codes to safe every worksheet in a workbook tot a new workbook.
But then the tabname/worksheetname in the new workbook is Sheet 1. What I need is code to save the sheets to a new workbook and rename the worksheet. The name has to be the same as the new workbookname. |
#2
|
||||
|
||||
What are those codes? They might just need a tweak.
|
Tags |
save as, workbook name, worksheet name |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Summing data from multiple worksheets in a workbook and placing into another worksheet | safrac | Excel | 17 | 10-04-2022 12:21 PM |
How can I copy a worksheet and paste values to another new workbook ? | DBenz | Excel | 1 | 01-26-2019 07:03 AM |
How do I populate Worksheets using information entirely from another Worksheet in the same Workbook? | BrieDanielle | Excel | 1 | 06-18-2016 10:50 AM |
Copying specific cells to a new sheets also give sheetname | dapeamel | Excel | 0 | 02-24-2015 09:20 AM |
VBA to save a workbook without the macros | OTPM | Excel Programming | 1 | 01-15-2014 12:42 PM |