Import .txt Files in Excel on 1 Sheet

[emoandy05]

Hello all,

Thanks in advance for your help.

I have a static folder in which I have saved 20 to 30 text files. I need to get the information in these text files into excel, all into column A, right after the other vertically. Right now I manually open each folder, copy the info, paste it into excel under last row of the previous data. An ideal macro would do this until all files in the fodler have been opened imported into excel.

Any help would be greatly appreciated.

Thank you.

 

[mole999]

whats the file names. are they in order, what would be the human import order

 

[emoandy05]

the files are named in the following format: "mm.dd.yy mod.txt" for example, "08.25.14 mod.txt". I would like them to be in order from oldest to newest if possible.