Yes, it is possible.

http://www.vba-programmer.com/

www.erlandsendata.no/english/index.php?t=envbadac (ADO/DAO as
well as Workbook and Folder Names)

All I can not help you with off hand is the actual searching. But as
long as you can search  in an open workbook, I think you can do the same
in a closed  workbook using ADO.