Use of the Indirect function on a closed workbook.

S

Surveymark

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?
 
S

Surveymark

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?
 
D

Dave Peterson

The link to Laurent's site worked ok for me.

I clicked on the English page and clicked the link to download the function and
that worked, too.
 
S

Surveymark

Thank you for all your help, there must be a problem with our network or
something beyond my knowledge, I sent the link to several people in my office
and no one here could get it to work. I guess I will try at home tonight.

THANKS!
 
T

Tom-S

I also just tried and failed to download the function. Does anyone know an
alternative? Or can anyone who has managed to download the xll from Laurent
Longre upload to somewhere else, please?

Tom-S
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top