save all csv as xls

[HarryKlein]

Hello,

I would like to save all csv files as xls in a directory.
I have created the attached macro, but the problem is, that in case this macro opens and save the csv files, the separation will be lost, data are separated by semicolon will be merged in one cel.
I tried to use the opentext method, but I couldn't manage to use it on all files in a directory.

Could anybody help, how to deal with this problem?


Thanks

Please Login or Register  to view this content.

[snb]

Whether the semicolon will be used as a fieldseparator is dependent on windows international settings.
If you change the fieldseparator into a semicolon there there shouldn't be any problem any more.

Please Login or Register  to view this content.

[HarryKlein]

Thanks, I checked the windows settings, and the fieldseparator is set to semicolon.
Your code is more efficient that my one, I am happy to have the possibility to learn.

[snb]

It would be interesting to know the contents of files that won't be parsed to columns, although they contain the semicolon as fieldseparator.

[HarryKlein]

I have attached a sample

[snb]

Your eyes must be better than mine...

I found it.

The only problem in that file is that you forgot hyphenation after the fieldname 'field2'.
If I save that file as an csv-file it's only that problem not parsing to columns.; everything else in that file turns out to be correct.

[HarryKlein]

Thank you for the help