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

--
ol
-----------------------------------------------------------------------
oli's Profile: http://www.excelforum.com/member.php...fo&userid=2400
View this thread: http://www.excelforum.com/showthread.php?threadid=47367

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

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

"oli" wrote:


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





--
oli
------------------------------------------------------------------------
oli's Profile: http://www.excelforum.com/member.php...o&userid=24000
View this thread: http://www.excelforum.com/showthread...hreadid=473677