I have an ASCII flat file, which may grow or shrink. I would like to read each line of data into an array. What is the most efficient way to get the number of lines (records) in a file and then Dim an array? This array is used in several different procedures throughout the form.
I have already Opened the file, read in each line and got a count that way, but it is slow. I've set an upper limit to the file size, but that is risky.