+ Reply to Thread
Results 1 to 4 of 4

Merge Multiple CSV files to one XLS with multiple tabs

  1. #1
    Registered User
    Join Date
    04-15-2021
    Location
    Orlando, Florida
    MS-Off Ver
    MS office
    Posts
    3

    Merge Multiple CSV files to one XLS with multiple tabs

    Hi everyone,

    I'm trying to merge multiple csv files within the same folder together. The code below works but only grabs the first worksheet tab of each csv file, some files have multiple tabs and the script is only grabbing the first tab of each file, would anyone know how I can merge all the csv files together into a single file while grabbing all of the original worksheet tabs?

    Thanks for your time,

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,570

    Re: Merge Multiple CSV files to one XLS with multiple tabs

    Welcome to the forum!

    In that case, they are not CSV files. CSV files only have one worksheet, so to speak. What you are asking is how to merge multiple workbooks and multiple worksheets into one workbook.

    Maybe:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-15-2021
    Location
    Orlando, Florida
    MS-Off Ver
    MS office
    Posts
    3

    Re: Merge Multiple CSV files to one XLS with multiple tabs

    Hi Mr. Kenneth Hobson,

    Thank you for your kind words and for your help! I'm sorry, you are correct, these are XLSX files.

    Yes, I am trying to merge multiple XLSX workbooks with all of their worksheets into one workbook.

    I changed the name of the variables in your code below to display xlsx instead of csv, I'm running the macro but nothing occurs, can you please guide me for what I'm doing wrong or need to add in order to complete this?

    Thanks for your help!

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    04-15-2021
    Location
    Orlando, Florida
    MS-Off Ver
    MS office
    Posts
    3

    Re: Merge Multiple CSV files to one XLS with multiple tabs

    I was able to solve my tasks with the code below, thanks again for taking your time to help me out!

    Please Login or Register  to view this content.

+ 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. [SOLVED] Merge Multiple CSV files to one XLS with multiple tabs
    By PY_ in forum Excel General
    Replies: 21
    Last Post: 05-07-2018, 07:19 PM
  2. Merge Multiple CSV files to one XLS with multiple tabs
    By waqar.b85 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-24-2016, 11:49 AM
  3. Merge Multiple CSV files to one XLS with multiple tabs
    By waqar.b85 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-23-2016, 06:54 PM
  4. Merge Multiple CSV files to one XLS with multiple tabs
    By waqar.b85 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-23-2016, 01:30 PM
  5. Merge Multiple CSV files to one XLS with multiple tabs
    By Punnurocks in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-09-2014, 09:08 PM
  6. [SOLVED] Merge Multiple CSV files to one XLS with multiple tabs
    By in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-01-1970, 12:00 AM
  7. [SOLVED] Merge Multiple CSV files to one XLS with multiple tabs
    By in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-01-1970, 12:00 AM

Tags for this Thread

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