Link to home
Start Free TrialLog in
Avatar of RavenTim
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
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RavenTim
RavenTim

ASKER

Awesome!  Works great!  Thanks Rgonzo1971!!
Works great!