Hi,
I written a macro to read in line by line multiple CSV files of varying
lengths.
Can anyone suggest a faster way in terms of runtime execution time to speed
this code up?
ie. I thought of reading in multiple lines in bulk to reduce I/O but VBA
doesn't seem to have a bulk read mode.
Basically i do the following:
Dim columnArrays as Variant
Dim newColumnArray as Variant
..
..
Do until EOF(inputFile)
Line Input #inputFile, inputLine
columnArray = Split(inputLine, ",")
....merge/massage/apply functions to certain columns in columnArray
and copy into newColumnArray
for i = 0 to Ubound(newColumnArray)
aRange.Offset(0,i).Value = newColumnArray(i)
next i
set aRnage = aRange.Offset(1,0)
Loop
Thanks to everyone for their valuable insights.
Bookmarks