Is it possible to make a macro that inputs all text files from the directory the workbook is located in and put the files name (text01.txt) as the first cell of the column the files data is inputed into? resulting in something like this:
test01.txt test02.txt test03.txt
xxxxxxxxxx xxxxxxxxxx xxxxxxxxxx
Bookmarks