It works for me...

http://xcell05.free.fr/morefunc/english/index.htm
--
HTH...

Jim Thomlinson


"Surveymark" wrote:

Thank You for the fast reply, however that is the web site that I tried. The
link to that function is no longer available. Any other thougths?
--
Surveymark


"Jim Thomlinson" wrote:

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

--
HTH...

Jim Thomlinson


"Surveymark" wrote:

I would like to use the indirect function to input data from various closed
workbooks. If I have the text "test" in cell A1, I would like to use the
indirect function in cell B1 to obtain data from file "test.xls." I can do
that, but when "test.xls" is closed, I get an error. I noted in a thread
that there was a function I could obtain from the Web site "Morefunc for
Excel" that would work with closed files. That web site no longer has a
working link to that function. Any other sites or help?
--
Surveymark