Thanks for the link dlsmith36. I found that in my initial searching and did used it as a starting point. I appreciate the input.
Here is an update.
I set up a couple of extra for loops to iterate thru the subfolders and each file and knock it against the part number listing I have in the excel sheet. And it seemed to be working when I stepped thru it but when I played the code from the beginning I get an "Input past end of file" error 62 on line
As I understand this error it means that excel thinks I am trying to read or assign something after an "end of file" character.
This tells me that excel can't read the file as it is not pure text. Since I have already wasted too much time on this thing anyways and no one else seems to know the answer either. I am going to go back to the tried and true method of beating my head against a wall for two days and rename the files manually (and yes I realize that if I just done it that way in the first place I would have been done already)
I am posting the last of my code, maybe someone will find it useful for something completely unrelated.
Bookmarks