find in closed workbook
 

I understand it is possible to get a cells data from a closed workbook via a
XLM macro if you know the location already, but is it possible to do more
advanced things like find a string and return the row its in? Or anything
else?

Thanks
Mark