Hi;

I have several(sometimes more than one) text files I import into Excel, then
use a couple of macros to format the info. Everything works fine, except I
would like to automate the importing and append the files after each other.

When I tried to do it, it creates several workbooks, then
I have to use another macro and copy and paste. This gets to be a pain, when
I have over 50 files. Is there a way to do this, please advise.

TIA -- Jack