Problem opening German .csv file with columns seperated by semicolons

[jakeb3482]

Ok so I can open the file manually fine but when I try to run a script to open and convert the files I can not get the formatting right. The columns do not separate.

I tried this to no avail:

Filename = german_file
Workbooks.OpenText Filename:=german_file, DataType:=xlDelimited, Tab:=False, Semicolon:=True, Comma:=False, DecimalSeparator:=",", ThousandsSeparator:="."

The German numbering uses the period as the thousands separator and the comma as the decimal separator. When opening the file manually, I change these settings under the International Options tab and then I choose semicolon in the Text to Columns option.

any help would be greatly appreciated.

Thanks!
Jake

 

[jakeb3482]

Gotta keep bumping this to the top or I feel it won't be seen

 

[Gerald Higgins]

Jake - I'm not a moderator, but bumping after only 21 minutes is probably not in accordance with the rules of the board.

It also may be counter-productive - there are many people on this board, myself included, who sometimes focus on un-answered threads. By bumping your own thread, you've made it look as if it's answered, and you may get less people reading it as a result.

In terms of a solution to your problem, have you tried recording a macro while you do the job manually, to see what code you get ?

 

[jakeb3482]

Rules are meant to be broken

I tried the script recording and that does not work either.