Transfer text file data to spreadsheet via vba

[Atom]

I am trying to selectively read a text file into a spreadsheet. Up until now I just copy and paste it in. This is fairly easy, but I'd like to be able to just load the parts of the file I want and have it load only the parts I want. The text file has a lot of extraneous information (180,000 lines) and I need less than 100. I have written some code to read the file and capture only the lines I want. Having done that, I want to transfer parts of the captured data into a range in a spreadsheet. Here's the code I have so far:

Please Login or Register  to view this content.

This is what the print statement produces:

Please Login or Register  to view this content.

So far, so good. I just want the 3rd and 5th columns of data to go on the spreadsheet. I know I can get this done by brute force, but it seems like there must be a simple way to transfer the data to an array and plug it into the spreadsheet, and I'd like to know what that might be without have to reinvent the wheel.

Thanks.

[AlphaFrog]

Try something like this (not tested)...

Please Login or Register  to view this content.

[Atom]

Worked great. Thanks.