Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-21-2017, 11:23 AM
chaverim chaverim is offline Split workbook into worksheets Windows 10 Split workbook into worksheets Office 2016
Novice
Split workbook into worksheets
 
Join Date: Nov 2017
Posts: 2
chaverim is on a distinguished road
Default Split workbook into worksheets

Hi,
I have got an Excel workbook with a few sheets in. I would like to split the workbook so that each separate sheet is transferred to a new workbook using VBA (in other words, split a workbook into many workbooks) and I would like to be able to choose where to save the new workbooks when the macro is running (meaning, open the save as dialogue).



Please advise me what to do.

Many thanks.
Reply With Quote
  #2  
Old 11-22-2017, 12:30 PM
chaverim chaverim is offline Split workbook into worksheets Windows 10 Split workbook into worksheets Office 2016
Novice
Split workbook into worksheets
 
Join Date: Nov 2017
Posts: 2
chaverim is on a distinguished road
Default

Link 1: https://www.excelforum.com/excel-pro...ml#post4788850

Link2: https://www.mrexcel.com/forum/excel-...orksheets.html
Reply With Quote
  #3  
Old 11-23-2017, 08:21 AM
NoSparks NoSparks is offline Split workbook into worksheets Windows 7 64bit Split workbook into worksheets Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

Quote:
(meaning, open the save as dialogue)
the 'save as dialogue' is file specific, meaning it would be needed once for each file being saved.
Apparently not what you want.

Care to post in this forum exactly what it is you do want and what typical sheet names would be ?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Split workbook into worksheets Summing data from multiple worksheets in a workbook and placing into another worksheet safrac Excel 17 10-04-2022 12:21 PM
How do I populate Worksheets using information entirely from another Worksheet in the same Workbook? BrieDanielle Excel 1 06-18-2016 10:50 AM
Add worksheets to workbook boboles Excel 2 01-26-2015 07:42 AM
Split workbook into worksheets I need an index file containing the names of all the worksheets in a workbook. retiredstuart Excel 3 09-12-2014 06:26 AM
split text files to worksheets (sheet1,sheet2,sheet3 soon sheet 25) gsrikanth Excel Programming 1 03-22-2012 11:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:35 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