Hey everyone and thanks for all your help in the past!
I'm trying to search for a value in a closed workbook and if that value is found, I would know that that unique ID has already been used and move onto the next number. I'm choosing to use the ADODB method instead of having it open in the...