By normal serach tool do you mean Instr functions or look up tool
such as MATCH or LOOKUP?
Also using FSO, would I be able to look up into the concerned excel
files without having to import it into my application ie. excel files
where the macro resides?