Extract from multiple .out files to one Excel worksheet

[Melissa Camp]

I have a series of .out files I usually manually import from text one at a time into Excel. After the first is imported I scroll to the bottom of the imported data and import the next set to the subsequent row, column 'A'. (For example if the first .out file has 30 rows I import the next file into A31) The number of rows changes but the data always goes out to column DM. Doing this 30 times in a row is tiresome.

I recorded a macro of myself doing this process once- ie the macro can import one .out file. I could really use a macro which imports the next .out file in the folder into the next row. Here is the macro I recorded:

Please Login or Register  to view this content.

The folder containing my .out files contains only the files I want imported and all of them should be included.

Any help would be sooo appreciated.


MODERATOR'S NOTE: This is a duplicate post and is closed. You can continue on in your most recent post.