Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 05-17-2019, 02:29 AM
JacquesW JacquesW is offline Windows 10 Office 2013
Novice
 
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 Windows 10 Office 2016
Expert
 
Join Date: Apr 2014
Posts: 253
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 10:47 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft