Trying to read in a CSV file into an Excel one when you open it
 

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?

Trying to read in a CSV file into an Excel one when you open it
 

Albretch,
If you double click on the .csv, does it open in Excel OK ?

NickHK

"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?

Trying to read in a CSV file into an Excel one when you open it
 

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?