+ Reply to Thread
Results 1 to 3 of 3

Separate tabs into different workbooks in same folder

  1. #1
    Forum Contributor
    Join Date
    01-26-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2013
    Posts
    154

    Separate tabs into different workbooks in same folder

    Dear Experts ,

    i will try and explain what i need to get done ,

    I have a workbook with many tabs say test1,test2,test3

    What i want the macro to do is loop through the tabs and create separate workbooks based in the same folder

    Say the workbook named "test.xls" is in a desktop and has tabs test1 ,test2 , test3 what i want the macro to do is create separate workbooks for each such tab and having same name as tab name i.e test1.xls , test2.xls etc containing the data contained in this tabs

    This new workbooks can be contained in the same location as the original workbook ,

    I attach a input parent file and outputted tabs which i would like ,


    Thanks in advance ,

    Humble regards ,

    Amlan Dutta
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Separate tabs into different workbooks in same folder

    Record yourself doing it, right click on the tab, and copy to new workbook, then save that workbook. This will give you a start on the code.
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Forum Contributor
    Join Date
    01-26-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2013
    Posts
    154

    Re: Separate tabs into different workbooks in same folder

    The solution to another project of mine at this link http://www.excelforum.com/excel-prog...ml#post3847616 by david (Username Tinbendr) helps me achieve my desired output for this project as well ...so i mark this thread as solved !
    David is awesome !

    Cheers ,

    Amlan Dutta

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 06-02-2015, 12:28 AM
  2. Separate Worksheets into Separate Workbooks
    By adileva in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-08-2013, 01:36 PM
  3. Replies: 4
    Last Post: 02-25-2013, 04:10 PM
  4. create a compressed folder or zipped folder then copy workbooks to it.
    By Ironman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-04-2012, 03:56 PM
  5. Macro to insert specified tabs to all workbooks in folder
    By need_some_help in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-04-2005, 05:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1