Hello,

I have som trouble by opening a csv file: if I do it normally in Excel with File/Open, then it works fine and I get the date in 4 columns (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, then it doesn't work the way I wish; it looks like this (everything in 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