open and consolidate .csv files

[Crispy85]

Hi Everyone,

I have this following problem.
I use a macro to open files from a certain folder.

I would like to do the same with several .csv files.
The macro does what it does: it searches a folder for files, opens the files, consolidates them in one sheet. No problem.

However, my output is really strange.
When i open one of these .csv files manually, everything is correctly divided into the right columns (somehow the semicolon seperator is automatically picked up when i open the file). But when i run the macro it doesn't do the same. So it seems there is a difference in opening the .csv file normal and opening it via the macro.
It's kinda hard to explain, but because i'm working with some privacy sensitive information, i cannot simply add a .csv file in to this topic.

I can add the code that i use, maybe someone sees something strange.

Please Login or Register  to view this content.

[Crispy85]

I created a sample file for the people who want to try and open the type of .csv file that i'm using.
I hope someone can help!

[Crispy85]

I would like to bump this, because i've been trying to find a solution anywhere but can't find any
Please use my script to open and import the .csv file to see the result.

[Crispy85]

I think i now found what happens. Whenever i open the .csv file normally it uses ; as a delimiter as it should.
But whenever i open the file thru the macro, it uses , as a delimiter.
Does someone know where i can change this , to ; so that the macro will use ; as a delimiter too?