As a last pitch here, you might want to browse this post by Harlan
where he provides the Function pull which works on closed workbooks:

http://tinyurl.com/dkgc8

(Link intentionally points to the "Show original" version in google to avert
problems in copy pasting the UDF)

You can read the complete thread at:
http://tinyurl.com/c6wpq

As I don't have experience using Harlan's UDF as yet,
start a new post if you need further help.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--