Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Open a Read-Only file in Excel 03 | Excel Discussion (Misc queries) | |||
how do i open a read-only or encrypted file in excel? | Excel Discussion (Misc queries) | |||
I am getting "unable to read" when trying to open an excel file | Excel Discussion (Misc queries) | |||
how do i open a file in excel that is encrypted or read only | Excel Discussion (Misc queries) | |||
Open Excel file as Read Only with code, | Excel Programming |