Re: Code To Open Files And Tell Me The Name Of File Where Data Is Located.
Quote from KjBox;792609
I also ran it on the files you sent and all was OK.
Yes that could well be the reason for the repeated file names. I did not take multiple entries of the same number in any single sheet into account as I thought it would not happen. Do you want me to amend the code to check for multiple instances of the number in a sheet and then stop the file name being repeated?
Only if it's an easy fix, don't worry otherwise