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