import all text files in folder

I am pretty new in VBA, so I hope I can get some help here.
I have a folder of text files. Their names and number can change.
I want to import them into excel, Either all into one workbook, different sheets, or each file into a separate .xls file.
Another thing is that I need all columns to be imported as text.
What I've achieved till now is a macro that imports one specific file, all columns as text.

Please Login or Register  to view this content.

How can I do this to all file in the folder?

Thanks in advance for your help

Thanks a lot!
With a few minor changes, this is exactly what I needed.
I have a few more questions, and I'll be glad if you or anyone could help me with them.
This process of importing data is done about once a day, and the text files might change (in number and name) throughout this time.
What is the best way to do this anew each time? With a macro? Delete all sheets at beginning of macro? I'll appreciate your advice.
The second issue is that I would like to name each sheet like the file name. How can I do this?

Thanks again for your fine help.

Thanks! That was excellent!