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