RavenTim
asked on
VBA Macro - Want to search for a string of data
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 "".
Thanks.
SeekFileNumber.txt
Thanks.
SeekFileNumber.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Works great!
ASKER