Import multiple text files to 1 column
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.