importing multiple text files into one worksheet and one column

hi there,

i read this thread and i am trying to do a very similar thing:

http://www.excelforum.com/excel-prog...ml#post2307276

i have many text files that need to be combined into one text file. the easiest way i can imagine is to use excel to achieve this.

all the text files have only one column and what i want to do is import each text file, take the data and place it ALL into one column on the activesheet.

is there a simple modification that can be done to the code in the above thread to achieve this? or is it simplier to write another vba code?

any help would be appreciated!

thank you very much!