Opening a text file copying a specific set of info for a list off numbers

dflak,

to answer your questions.

1) please use the 'parts list' tab and read the part numbers in column A and column C if possible

2) No we cannot depend on them being the same line each time, we can use the first one that appears (as they always should be the same) - to find the first I always such for "0 TR" and then look for the number after it.

3) I only sent 9 directories to show you what I mean and what the mpf looks like. There are over 5000 directories also, I just couldn't zip them all. I can send you more if needs me? they are all in the same location each time (G:\Trimming)

4) If you cant find a directory we can just skip over and im guessing the code will enter N/A?

if you need any more info let me know.. Appreciate your help!!!

just want to clarify,

when we are searching the part number in the directory from Columns A or C, does it search an exact search, e.g. word for word. Or can it pick up characters?