Results 1 to 18 of 18

Combining many .CSV files with a ";" delimiter into a single .XLS file with header row

Threaded View

emilx3 Combining many .CSV files... 02-24-2016, 10:53 PM
emilx3 Re: Combining many .CSV files... 02-25-2016, 06:36 AM
alansidman Re: Combining many .CSV files... 02-25-2016, 06:40 AM
Doc.AElstein Re: Combining many .CSV files... 02-25-2016, 01:20 PM
emilx3 Re: Combining many .CSV files... 02-25-2016, 06:24 PM
Doc.AElstein Re: Combining many .CSV files... 02-25-2016, 08:09 PM
Doc.AElstein Re: Combining many .CSV files... 02-26-2016, 02:36 PM
emilx3 Re: Combining many .CSV files... 03-10-2016, 07:56 PM
jindon Re: Combining many .CSV files... 03-10-2016, 10:00 PM
jindon Re: Combining many .CSV files... 03-11-2016, 05:53 AM
emilx3 Re: Combining many .CSV files... 03-11-2016, 06:54 AM
jindon Re: Combining many .CSV files... 03-11-2016, 07:07 AM
emilx3 Re: Combining many .CSV files... 03-11-2016, 07:21 AM
jindon Re: Combining many .CSV files... 03-11-2016, 08:10 AM
emilx3 Re: Combining many .CSV files... 03-11-2016, 03:28 PM
Doc.AElstein Re: Combining many .CSV files... 03-11-2016, 04:32 PM
  1. #13
    Registered User
    Join Date
    02-24-2016
    Location
    Copenhagen, Denmark
    MS-Off Ver
    2013
    Posts
    8

    Re: Combining many .CSV files with a ";" delimiter into a single .XLS file with header row

    Quote Originally Posted by jindon View Post
    It should read all rows.
    Hi Jindon

    I think we are close to a solution Could I ask you to try a couple of my original files? I will need to combine 20 files like those I have uploaded again. There might be a slight problem with a thousand separator, but I think that is easy to fix once the rest is sorted.

    Right now, when I run your script with the files I have now uploaded I get the following: billede 2.jpg

    Thank you, Emil
    Last edited by emilx3; 03-11-2016 at 07:56 AM. Reason: Picture inserted

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Function delimiter changed from "," to ";"
    By Franco403 in forum Excel General
    Replies: 5
    Last Post: 08-31-2015, 11:51 AM
  2. [SOLVED] Replace all BLANK cells in column with header title "Balance" to "0"
    By ks100 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-21-2014, 09:25 AM
  3. Replies: 3
    Last Post: 11-05-2010, 03:06 PM
  4. Transfert cell values from file "A" to file "B" skipping columns in file "B".
    By Sentrosi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2009, 11:11 PM
  5. Export to CSV file using "|" as the delimiter
    By William in forum Excel General
    Replies: 1
    Last Post: 07-04-2006, 07:25 AM
  6. [SOLVED] How do I change file/open/"files of type" to default to "all file.
    By How do I change"files of type" default in forum Excel General
    Replies: 1
    Last Post: 04-19-2005, 06:06 PM
  7. Macro Help- combining "CS" files
    By Judyt in forum Excel General
    Replies: 1
    Last Post: 02-18-2005, 10:06 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