Importing Text - Specific line, stacked on a single sheet?

**samickguy15** · 11-10-2009, 06:27 PM

I've found two links that perform ALMOST what I want, but I am code illiterate, so I could use some help.

I've got 1,500 text files, each composed of three lines, looking like this:

%
M029105 1638745 2 5/11/2009 94839 5.122
%

I am needing to import these into a single sheet, fixed width, stacking just the data from the second line. After that, I can sort as I need with the regular functions.

Can anybody help me out here? Here's the links that are almost what I want.

Importing Multiple Text

Specific Line & Stacking

**JBeaucaire** · 11-10-2009, 08:47 PM

You want the data from each file all in one cell, or parsed out to individual columns?

**JBeaucaire** · 11-10-2009, 09:21 PM

This macro will load in all the text files in the directory noted, edit to your path where the text files are stored. It will also parse out the data to separate columns. IF you don't want that, remove the blue code noted near the bottom:

Please Login or Register  to view this content.

**samickguy15** · 11-11-2009, 10:33 AM

Originally Posted by JBeaucaire

You want the data from each file all in one cell, or parsed out to individual columns?

I'd like the data parsed out to individual columns, and then the data from each file to come in to the row below the previous.

I'm going to try that script right now and see if it works like I need. Thanks for the quick response!

**samickguy15** · 11-11-2009, 10:37 AM

The code worked, except it gave me an error for the blue code. When I removed it, it imported it as I need, except each data group is in a single cell. I'm going to look at the links I posted to see if I can figure it out, but anybody who wants to beat me to it is appreciated! LOL

**samickguy15** · 11-11-2009, 10:44 AM

M029105 1638745 2 5/11/2009 94839 5.122 4.811 3.683 4.369 3.262 4.693 3.288 3.866 3.971 4.545 5.349 5.109 0.0 0.0

Here's a full line of text, I'm not sure if that has anything to do with the arrays or not...

**samickguy15** · 11-11-2009, 10:58 AM

I just used the text to columns function to split it out, but it would be nice to have as a complete macro if somebody could help me out. Thanks!

**JBeaucaire** · 11-11-2009, 12:32 PM

You're using Excel 2000, so perhaps the Text To Columns syntax I recorded is slightly different.

Use your macro recorder to record your actions as you apply the text to columns to the column A data the macro I gave you created. Then put that recorded macro in place of the blue code originally gave you.

Post up your version of the blue code so I can see the difference, if you don't mind.