Simple multiple TXT file opening in a workbook in different worksheets

Hi all,

I have the following simple vba code in order to open/import 1 txt file at one time

HTML Code: 

which is what I want to do by selecting a location instead of running the code for each and every file. Please, note that I do not have a specific number of txt files. They can be 30 or 300.

I am looking to find a code in order to tweak it according to the above, so I found the following one:

HTML Code: 

which unfortunately doesnt do what I can get with the 1st code.

In general, for a same procedure (which works well) but for .xls files I have this code:

HTML Code: 

Is there any way to fix the first code working in the same way as the above works? I am looking around, I havent found anything which could do the above one with txt - working as the first code.

Lastly, I found this code:

HTML Code: 

but still doesnt work for all the txt files. It stops after the first one or two and returns error - probably it is an issue of renaming but still I cant get it work