I have read in a CSV file. I want to take the fifth element of each line and
put it in an array. I tried the code below. arrWeight has been defined as
Variant.

When I run this, it comes back with type mismatch error.

Do While Not EOF(intFileNum)
Line Input #intFileNum, strWholeLine
arrLine = Split(strWholeLine, ",")
arrWeight(i) = arrLine(5)
i = i + 1
Loop