+ Reply to Thread
Results 1 to 3 of 3

Combine multiple files in one, under separate worksheets

  1. #1
    Forum Contributor
    Join Date
    03-02-2014
    Location
    usa
    MS-Off Ver
    MS 365
    Posts
    593

    Combine multiple files in one, under separate worksheets

    Hello,
    I have multiple files in a folder.
    The files are named:
    File1.xls
    File2.xls
    File3.xls
    ….and so on; the number of files varies.
    I am trying to write a macro, to combine all *.xls files in one workbook having each file as a separate worksheet.
    Please advise.
    Thank you

  2. #2
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Combine multiple files in one, under separate worksheets

    Please Provide the sample files its make easy to resolved
    Thanks - Naveed
    -----------------------------
    If the suggestion helps you, then Click * to Add Reputation
    To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
    1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Combine multiple files in one, under separate worksheets

    I think you are asking for this solution.

    https://sites.google.com/a/madrocketscientist.com/jerrybeaucaires-excelassistant/merge-functions/wbs-to-sheets
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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: 2
    Last Post: 06-17-2014, 11:16 AM
  2. [SOLVED] VBA to save multiple worksheets as separate CSV files using name of worksheet
    By Yg74 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-20-2012, 10:55 AM
  3. VBA to save multiple worksheets as separate CSV files using name of worksheet
    By titushanke in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-20-2012, 08:08 AM
  4. combine multiple worksheets & files into 1
    By Barb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-07-2005, 07:05 PM
  5. [SOLVED] Combine Workbooks as separate worksheets
    By SAL in forum Excel General
    Replies: 2
    Last Post: 06-01-2005, 12: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