Ah, nicely done. I love the FSO and TS objects, they make a lot more sense to me then the built in VBA text methods. AND FAST, TOO!
Here is the tutorial I used to learn to the FSO:

http://www.techbookreport.com/tutorials/fso1.html


I cant import the text file into excel becuase it's over 100k lines long.
Lies, LIES I TELL YOU!

You can always pull in the data 60,000 lines at at time and use multiple worksheets. Bill Jelen (Mr.Excel) has a good routine for doing this. Or, if your array is 1D, just do 60,000 lines at a time and put them into multiple columns on the same sheet. Then again, it all depends on exactly WHAT you are going to do with your data.

As for redimming every time, if you know roughly how big your array will be, just dim it once at 25% oversize, and keep count of the elements you add. Then just redim it once at the end, or never if the blank elements at the end don't bug you.



Edit:
"Wend"? Damn, you must be old school...