I am looking for a VBA Excel code to find a set of strings and return file name and path. The string may be in any of the sub folders and code should return the exact file name and path to show where it is located.
For e.g. I have a spread sheet with a list of check numbers (number or text) available in column A, i.e. from cell A2 to A20. The code should execute and select a master path then it should return the file name and file path to show where the check number is located.