wrong divider in csv-file

[ptrolle]

Hi

I am searching for a solution to this little problem:

when saving a spreadsheet in csv-format from the user interface of Excel (a Danish version), the file is saved with a ";" as divider (Danish), which is what I want, but when the saving is executed in code like the code below, the file is saved with a "," as divider (USEnglish). When the file then is opened in Excel, each row of data are placed in one cell instead of multiple cells.

Please Login or Register  to view this content.

Please help me as I have a deadline in two days

trolle

[Richard Buttrey]

Hi,

Probably the simplest way is to just select the single column and use the Data Text to Columns functionality and pick the ';' delimiter.

Alternatively you could temporarily change the list separator in the regional settings before opening the file.

HTH

[ptrolle]

Thank you for the fast answer.

Unfortunately your solutions are not applicable in this situation as the csv file is to be used by another application of which I know nothing. So I am forced to deliver the csv file in the "proper" format. The strange thing is, that it is only when the saving is done by the VB-code the problem arises. When saving is done from the Excel user interface, the csv file is delivered in the wanted format. I have checked the settings with this snippet:

Please Login or Register  to view this content.

and the settings are correctly set (Danish) but the code executor insists on delivering in USEnglish!!

greetings trolle

[protonLeah]

The macro below will build a string of semi-colon delimited string from each row of your file and put that string in the first cell of the corresponding row of a new sheet. So when it is done, you will have a single column of semi-colon delimited values. The sheet is moved and saved as a CSV file.

Please Login or Register  to view this content.

[ptrolle]

Hi

Thank you for your inputs. I couldn't use any of your solutions but they inspired me to a simple and workable way to create the wanted output:

Please Login or Register  to view this content.

Thank you

greetings trolle