JE McGimpsey shows how to get a value from a closed workbook he
http://www.mcgimpsey.com/macoffice/e...cellvalue.html
if you know exactly what cell has the value. Since you want to do a
search, I believe you will have to open the workbook.

Hth,
Merjet