Loading CSV files into Worksheets
Posted by Ron Dionne on October 15, 2001 1:38 PM
I'm opening a series of .CSV files into Excel in order
to do some statistical analysis. I'm using the
Workbooks.Open function to do this. Unfortunately,
This creates a seperate Workbook for each file, so I
end up accessing the data like this:
Since I'm using automation from VB, this process
is very slow. If could instead load the data into
Worksheets under one Workbook, I would think that
it would speed things up a bit since I would be
getting rid of one level of object hierarchy.
I could access the data like this:
Worksheets(j).Cells(l,m) and not need the reference
to the seperate workbooks.
Oh Excel guru, please show me the way.