Microsoft Office Forums

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: 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
  #2  
Old 05-18-2019, 10:39 AM
p45cal's Avatar
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: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
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
Save each worksheet as new workbook with the sheetname=workbookname 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:44 AM.


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