I am trying to write a macro that will search an excel table that has pre-determined locations that need to be searched. For example, when the macro is run I would like it to loop thru the locations and search for any file extensions with *.xls. (later on I may need to add several extensions to search for as well). If that location has a file with that extension I would like it to return a "Yes" back in the table. Here is a dummy table that closely resembles what I'm looking at. I am looking at a table that would look through 200 locations on 5 different drives


Bank Name File Location .xls file?
Bank A H:\BankA\file (return yes or no)
Bank B P:\BankB\file (return yes or no)