Importing multiple .txt files

Good day,

I came across a couple of threads that are somewhat related to my problem, but am really new to creating a macro that I feel more comfortable getting details specific to my issue.
So I have data in the form of multiple .txt files that I usually import manually. I was able to record a macro of what it is that I am doing, and was able to loop it to repeat, but I would like to have the macro access all the .txt files in the folder and manipulate them in the same way, with a column separating each file (in one spreadsheet). How do I change the macro so that it goes thru each .txt file without me having to specify the exact file name?

Please Login or Register  to view this content.

Not sure if there's a way to do an entire directory, but it might be possible if you created a list of all the files. Here are some ways to export the contents of a folder into a list.

Then make your filename a variable that works its way down the list as you go.

I would suggest testing this in a separate folder with maybe 3 or 4 txt files. No sense sitting there for an hour only to find out it didn't work.

Hi dominiquetrix,

What is your delimiter in the text files? Tab, space, both or sometimes either. The reason I ask is that in your original macro that you recorded you had both boxes for Tab and space delimiter checked. If you only need one, then your code can reflect this.

abousetta