Opening a csv file

[oli]

Hello,

I have som trouble by opening a csv file: if I do it normally in Exce
with File/Open, then it works fine and I get the date in 4 column
(AbJahrMonat in A, Code in B, Name in C and Wert in D):

AbJahrMonat Code Name Wert
200507 P01 Produkt1 0,0225

I registred the generated macro, it looks like this:
die entsrechende Makro habe ich registriert, es sieht so aus:

Sub Macro1()
'
' Macro1 Macro
' Macro enregistrée le 05/10/2005 par Olivier
'

'
ChDir "C:\temp"
Workbooks.Open Filename:="C:\temp\myfile.csv"
End Sub

After the registration, if I run the macro, for example with F5, the
it doesn't work the way I wish; it looks like this (everything i
column A):

AbJahrMonat;Code;Name;Wert;
200507;P01;Produkt1;0 0225;

How can I do to automatically get the data in 4 columns by open ?

Thanks you.

Olivier


:confused

 

[Guest]

Workbooks.Open "C:\temp\myfile.csv", 2

this is very clear in HELP on the workbook OPEN item. The second parameter
is the format.