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

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