Thread: Save each worksheet as new workbook with the sheetname=workbookname
View Single Post
 
Old 05-17-2019, 02:29 AM
JacquesW JacquesW is offline Windows 10 Office 2013
Novice
  
Join Date: Jan 2012
Posts: 21
JacquesW is on a distinguished road
Default 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.
Reply With Quote