If it is a string  "Error" You could search  using the normal search tool.

You would need to use the FSO to find all the .xls files  in a directory

You would open each of them and then search for the string. The search will
return a value which can be interpreted as "found" or "Not Found" You would
use this result to set a flag which will indicate if the string was found.