|
|
#1
05-17-2019, 02:29 AM
|
|||
|
|||
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. 
|
| 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 |
Windows 10 
Office 2013
Threaded Mode