fairly goof proof way to read a text file into an array
Code:
Dim str() as string
Dim tmp as String
Open "myfile" for input as #1
tmp = input(LOF(1),1)
str=Split(tmp,vbCrLf)
The number of array elements is Ubound(str)