+ Reply to Thread
Results 1 to 7 of 7

Combine files

  1. 01-23-2009, 04:15 PM #1
    TinaK819
    TinaK819 is offline
    Registered User
    Join Date
    08-15-2008
    Location
    Central New Jersey
    Posts
    37

    Combine files

    Hello,

    I have a scenario here and i really dont even know where to start. If anyone can help me with some code for this project that would be great.

    I have a folder that contains several subfolders (10-20). Within each subfolder is a number of excel files (the number of files varies) that contain 2 worksheets each.

    What i am trying to arrive at is one file for each subfolder that has the first tab of each of the files. The original files contain links, so the values and formats must be pasted. It woul dbe great if all of the new files could be saved in the main folder among all of the subfolders.

    It would be especially great if each tab could be named for its respective file and each new file for its respective folder.

    Thank you for your help!!!
    Last edited by Andy Pope; 02-14-2009 at 08:55 AM.
    Reply With QuoteRegister To Reply
  2. 01-27-2009, 04:36 PM #2
    TinaK819
    TinaK819 is offline
    Registered User
    Join Date
    08-15-2008
    Location
    Central New Jersey
    Posts
    37

    Re: Combine files

    I see that many people have looked at my request and no one has replied. Is this a hard program to write?
    Reply With QuoteRegister To Reply
  3. 01-27-2009, 06:17 PM #3
    StephenR
    StephenR is offline
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Combine files

    Not hard perhaps, but involved. Let's say you have the following simplified set-up:

    Folder1
    - Sub-folder1
    - file1
    - file2
    - Sub-folder2
    - file3
    - file4

    Then you want a file created with two sheets, the first being a copy of sheet1 of file1 (named file1) and the second being a copy of sheet1 of file2 (named file2). You want this file stored in Folder1 and you want it called Sub-folder1. Repeat for Sub-folder2 etc

    Have I understood you correctly?
    Reply With QuoteRegister To Reply
  4. 01-27-2009, 08:00 PM #4
    TinaK819
    TinaK819 is offline
    Registered User
    Join Date
    08-15-2008
    Location
    Central New Jersey
    Posts
    37

    Re: Combine files

    Exactly! I appreciate your reply!!
    Reply With QuoteRegister To Reply
  5. 01-28-2009, 08:20 AM #5
    StephenR
    StephenR is offline
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Combine files

    Don't get too excited - I haven't done anything yet!

    But I will try to look at later, if no-one else has intervened in the meantime.
    Reply With QuoteRegister To Reply
  6. 01-28-2009, 01:43 PM #6
    StephenR
    StephenR is offline
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Combine files

    OK, try this. I did a little test and it seems to work. Put this in a blank or your personal workbook and it will create the requisite new ones. Come back if you have problems/queries.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 01-30-2009, 03:07 PM #7
    TinaK819
    TinaK819 is offline
    Registered User
    Join Date
    08-15-2008
    Location
    Central New Jersey
    Posts
    37

    Re: Combine files

    I will test this early next week. Thank you very much!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1