I found a piece a VBA code to use as a macro that searches through a folder of excel files to find a file number within a worksheet(s) in the folder. However, this code requires you to match the file number exactly. Can somebody look at the attached and change it so it will find a string of data
within the sheets? Basically looking to change it from fileNumber = ""
to fileNumber Like ""
or fileNumber contains ""