I have a list in excel which I often export to CSV. It works well, I get a list with ";" as separator and "," as sign for decimals which is the standard in Sweden.
Then I record a macro doing this task and it works fine. Until I run the macro! Visual Basic uses "," as separator and "." as sign for decimals and this is of course fatal and the file does no work.
I have learnt that csv is different in US than in Europe.
Question is:
How do I make a CSV-file in VB that meets european standards (";" and ",")?
Marten
Bookmarks