"Salman" wrote:
Thanks for your precious time & efforts

No prob. Sorry that I couldn't be of further direct help. In case nobody
else jumps in here, I found this recent posting by Dave Peterson which might
be of interest / relevance to you:
--- ---

" Harlan Grove wrote a UDF called PULL
that will retrieve the value from a closed workbook.

You can find the function at Harlan's FTP site:
ftp://members.aol.com/hrlngrv/
Look for pull.zip

Laurent Longre has an addin (morefunc.xll) at:
http://xcell05.free.fr/

That includes =indirect.ext() that may help you.

wrote:
I assume then that there is no way to link dynamically to a closed
workbook without using some kind of macro.
---- ---

I'm afraid I don't have experience using either of the above, so I'm not
sure whether it'll work for your intents here ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---