.csv file

[alexander_fleck]

Hey,
I' ve got a .csv file that contains the following, opened with an editor:

1;2
2,4
3;6
4;8

When I double-klick the file, Excel shows it like above. But when I first start Excel and open the file with the open dialog, it' s shown like this:

1 2
2 4
3 6
4 8

The values' re seperated into cells. How can I get the first output using VBA?
Thanks,
Alexander Fleck.

[alexander_fleck]

Hey,
I solved it by myself. I' ve to set the lines into "s, like:
"1;2"

I don' t know the english word for "s.

Thanks,
Alexander Fleck.

[salvelinus]

Originally posted by alexander_fleck
I don' t know the english word for "s.
Alexander Fleck.

Double quotes, or quotation marks.