VBA to read text file and import specific data from it to excel columns

[Paul_Hossler]

Thank you very much!! this actually works.. my only issue though is that the text file I have is what i have just sent but repeated a million times. So it would be really hard for me to separate each line. is there any way I can separate/parse this text file through vba before proceeding to the code you have sent me?

1. Again, I'd / we'd have to see the file to be sure.

2. It depends on what you want to get out. "AverageSize" is repeated many times; what do you want to do