Import CSV file

[JeDD21]

Hello,

i am new at this forum, i don`t often open new topics, the search function helps me to solve most of my problems. Right now i am working on a difficult code, i think i have the right idea but the code wont work.

I have many csv files, very many. I am trying to import them with an vba code and put each word what is important for me, in an array. The code i am using should do so, but there`s an error code: Object required. I want to explain what i want to do:

This CSV file contains 10 Columns, there are only 5 important to me, the first, the second, the third, the fourth and the sixth. In this csv file theres everything in column A and i have not only 1 separation symbol, i have , ; : . and - but the first - should be ignored, starting with ; then separate after ,

The code i have should do the import, when this works it wont be difficult to do the other steps, the separation after : ; - (I can replace each Symbol to ,)

My second problem is: i want to create a small menue where i can write the name of my csv file, after clicking on it it should do the import. But there are files with similiar names, a small list would be perfect. I have some idea, but i hope i will get some tipps how to do it better.

Here is a sample file.

regards