How to Import only specific colounms from CSV file

[Denmark]

Hi ,
I am new here and with VBA as well and I really need some help how to do below challange.
I have found below file to import all CSV files in a folder and it works, but....What I really need is that the VBA code only copys out colounm K,L,R and S from the CSV files in the folder
and place it from colounm A1 to D2000.

And if it is possible maby show a list of all the imported files without the hole filePath so only the file(s) name(s) are shown in the msgbox.

I really appreciate if someone can help me out to solve this for me very big issue.

With thanks,
Denmark

PS
My CSV files are semicolon separated.

Please Login or Register  to view this content.

[mehmetcik]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[Denmark]

mehmetcik
Sorry, as I said I´m new but I´ll try again hopfull that I have understand that you mean.

[mehmetcik]

Code Tags

Hopefully a moderator will add the code tags for you.

No One can help until they are added. Which is frustrating for us as well as to you.


Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html

[Denmark]

mehmetcik,
Thank you, I think I understood what you meant by tags.

[nigelog]

If I understand correctly

try change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[Denmark]

Hi nigelog,
Thanks for your replay. I have tried your suggestion but I´ve got an compile error "For each control variable must be variant or Object".
What am I doing wrong??

[nigelog]

I dont have the workbook or input csv files so not tested

Try

Please Login or Register  to view this content.

at second look you are going to have to try emulate this process into your code

Please Login or Register  to view this content.

[Denmark]

Hi nigelog,
jep the først and the second fil do not work. It gives desame error.
I will tomorrow try the third code you send. My biggest challange is to figer out how the code exactly works, as VBA still is very new for me.

[jindon]

Try

Please Login or Register  to view this content.

[Denmark]

Hi Jindon,
Thank you very very much - your code works perfectly
Just one last question to your code. There is a empty row between each file and headers names from the following importes files - How do I get rid of this empty row(s) and headers between each file, so I only keep the headers from the first imported file in colounm 1 ?

[jindon]

File might have extra carriage return at the end....

Try change to

Please Login or Register  to view this content.

[Denmark]

Hi Jindon,
many many greatful thanks for your help. It works fantastic.