convert cvs to xls - Semicolon delimited

[frhling]

Everyday some csv files are generated under linux.
Now everyday the files should be converted to xls.

I have found a code:

Please Login or Register  to view this content.

seems it doesnt work by semicolon. as all goest into 1 cell.

is there anyone who can help me?

[Norie]

As far as I can see you don't specify ; as the delimiter anywhere in the code.

[RHCPgergo]

.csv can be opened by excel and displays as table, so why convert?

[Norie]

In your title you seemed say the delimiter was a semi colon not comma.

Is that not the case?

[arlu1201]

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.

[frhling]

As far as I can see you don't specify ; as the delimiter anywhere in the code.

2 tell the truth, I just chaned: Semicolon:=True and all other things False. I dont know what else should be changed. I am NULL in VBA Programming.

[frhling]

.csv can be opened by excel and displays as table, so why convert?

I know they can be opened in excel, but as I have seen I couldnt save any diagram in it. I want to change that code in a way that all my csv which are generated everyday can be changed to xls so that I can make a change in it.

[frhling]

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.

Thanks. Next time I pay more attention.

[martindwilson]

Please Login or Register  to view this content.

that bit run on its own works fine