workbooks.Open "C:\Myfolder\Mydoc.csv"

would be the VBA. If you want to import into an existing file, then turn
on the macro recorder and import it through Data=Import External Data.

When the data is in, turn off the macro recorder and look at the code
recorded.

--
Regards,
Tom Ogilvy


"Albretch" wrote in message
news:13249998.1109826249790.JavaMail.X@x-0yc08mu0lvpns...


Hi

I have a nicely formatted csv data file containing only decimal numbers

I need to open it using an excel blank '.xsl' file that would insert the
data
into it

I have tried a number of things to no avail and I think it should be
straight
forward since ".csv" is a native format to excel

How do you read in a csv data file into an opening excel one?

Can anyone point me to some example code?