+ Reply to Thread
Results 1 to 2 of 2

Merge Multiple CSV files to one XLS with multiple tabs

  1. #1
    Registered User
    Join Date
    10-11-2018
    Location
    Cape Town
    MS-Off Ver
    Office365
    Posts
    1

    Merge Multiple CSV files to one XLS with multiple tabs

    I am on Mac High Sierra with Office365 Excel version 16.18 (181008).

    I am using the macro described here: ---You are not allowed to post any kinds of links, images or videos until you post a few times.---

    However, the macro only opens one of the .csv files from the import directory and successfully adds it as a tab in the workbook. The other .csv files seem to be ignored. Could someone please help me?

    My version of the Macro:
    Please Login or Register  to view this content.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,925

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

    I am surprised Excel is letting you get away with
    Please Login or Register  to view this content.
    I think this should be
    Please Login or Register  to view this content.
    Aslo Dir() instead of plain Dir
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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

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