Microsoft Office Forums Save each worksheet as new workbook with the sheetname=workbookname

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-17-2019, 02:29 AM
JacquesW JacquesW is offline Save each worksheet as new workbook with the sheetname=workbookname Windows 10 Save each worksheet as new workbook with the sheetname=workbookname Office 2013
Novice
Save each worksheet as new workbook with the sheetname=workbookname
 
Join Date: Jan 2012
Posts: 19
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
  #2  
Old 05-18-2019, 10:39 AM
p45cal p45cal is offline Save each worksheet as new workbook with the sheetname=workbookname Windows 10 Save each worksheet as new workbook with the sheetname=workbookname Office 2016
Expert
 
Join Date: Apr 2014
Posts: 280
p45cal has a spectacular aura aboutp45cal has a spectacular aura aboutp45cal has a spectacular aura about
Default

What are those codes? They might just need a tweak.
Reply With Quote
Reply

Tags
save as, workbook name, worksheet name

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
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
Summing data from multiple worksheets in a workbook and placing into another worksheet safrac Excel 3 08-19-2014 01:16 AM
VBA to save a workbook without the macros OTPM Excel Programming 1 01-15-2014 12:42 PM


All times are GMT -7. The time now is 04:45 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft