Import multiple text files to 1 column

Import multiple text files to 1 column

Hello All,
I have been using the following code to import text files into 1 excel sheet. This code takes file 1 and imports it into Column A. The next file it puts in column B. the problem is I need code to all the txt files into column A? is there a way to make this macro import everything into 1 column?

excel Version = 2007

Please Login or Register  to view this content.

thank you for updating the code tags. I have added a description of the probelm to the original post.