Problems with opening a .csv-file in a excel spreadsheet

[JohanBS]

When I open the .csv-file with VBA in a Excel spreadsheet (excel 2002) the files are not put in the right colums.
The data in the file are separatet by semicolons, but when
I open the file with the following codes:

Workbooks.Open Filename:=
or
Workbooks.Open Filename:= , Format:=xlCSV, Delimiter:=";"

the data get separatet by the commas instaed of semicolons.

The file is no damished because when I open it manually in excel the data are in the right colums. I have also opened the file in wordpad where I can se that the the data are perfectly separatet by the semicolons



Johan

 

[combo]

The Delimiter works when Format is set to 6 (xlCSV).
There is more to set when opening text file with
[tt]Workbooks.OpenText ...[/tt]

combo