Open Text File in order which is look like in folder

[mohan.r1980]

Hello Friends,

i have a multiple text files in a folder and i am opening it one by one.
Filename of each text file like "04082016_92.txt", "04082016_93.txt", "04082016_94.txt", "04082016_100.txt"

filenumber is not in same digit so macro try to open "04082016_100.txt" file first.
i want to open each text file in order as it shows in folder.

Please suggest

[TMS]

In principle, I think you need to:
1. loop through the files in the folder
2. Store the file names in a temporary worksheet
3. Use Text to columns to separate out the nnn.txt part of the file name (into a new column)
4. Use Replace All to remove the .txt part of the cell to leave only the numeric part.
5. Sort on the number column to get them in the correct order
6. Loop through the sorted stored file names
7. Open and process each file

Sorry, I don't have time to do this but you already have a loop and you should be able to get most of the rest by recording macros.

[mohan.r1980]

thanks for quick reply.
i will manage as you suggest

[TMS]

You're welcome.