Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reading a CSV file into an Excel w/b
I'm guessing, from the posts I've seen, that the following code will
open and read the contents of a CSV file: Sub read_file() Dim strTemp As String Dim arline As Variant Open "c:\temp\myfile.csv" For Input As #1 Do While Not EOF(1) Line Input #1, strTemp arline = Split(strTemp, ",", -1, vbTextCompare) Loop Close #1 End Sub What I would like to know is, how do I get the data that is read from the CSV, into my Excel w/b? I have a number of CSV files that I am sent monthly, which need to be placed into a master w/b. Some data manipulation needs to be performed on the read data, e.g. dates appear in the format 'yyyymmddhhmmss' and need to be converted to 'dd/mm/yyyy hh:mm:ss'. So, I guess my question is two-fold: 1. How do I get the data read in, and into the spreadsheet? 2. When do I perform the data manipulation and then get it into the appropriate cells in the spreadsheet? Many thanks for your help Duncs |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reading a CSV file into an Excel w/b
Hi Duncs
I'm actually working on a similar project. From what I know, there is no need for special importing in order to open a csv file into Excel. I simply double-click the csv file in Wondows explorer and Excel opens it like any ..xls file. Then I manipulate the data like usual, with Excel functions. I'm sure there are limitations but you should be able to do your date changes. "Duncs" wrote: I'm guessing, from the posts I've seen, that the following code will open and read the contents of a CSV file: Sub read_file() Dim strTemp As String Dim arline As Variant Open "c:\temp\myfile.csv" For Input As #1 Do While Not EOF(1) Line Input #1, strTemp arline = Split(strTemp, ",", -1, vbTextCompare) Loop Close #1 End Sub What I would like to know is, how do I get the data that is read from the CSV, into my Excel w/b? I have a number of CSV files that I am sent monthly, which need to be placed into a master w/b. Some data manipulation needs to be performed on the read data, e.g. dates appear in the format 'yyyymmddhhmmss' and need to be converted to 'dd/mm/yyyy hh:mm:ss'. So, I guess my question is two-fold: 1. How do I get the data read in, and into the spreadsheet? 2. When do I perform the data manipulation and then get it into the appropriate cells in the spreadsheet? Many thanks for your help Duncs |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reading Excel File in VC++ | Excel Programming | |||
reading txt file and copying the lines in new excel file | Excel Programming | |||
macro reading excel file | Excel Programming | |||
reading from text file to excel file | Excel Programming | |||
Reading CSV file from Excel (VBA) | Excel Programming |