|
Use of the Indirect function on a closed workbook.
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 |
Use of the Indirect function on a closed workbook.
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 |
Use of the Indirect function on a closed workbook.
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 |
Use of the Indirect function on a closed workbook.
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. 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 -- Dave Peterson |
Use of the Indirect function on a closed workbook.
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 |
Use of the Indirect function on a closed workbook.
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! -- Surveymark "Dave Peterson" wrote: 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. 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 -- Dave Peterson |
Use of the Indirect function on a closed workbook.
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 "Jim Thomlinson" wrote: 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 |
Use of the Indirect function on a closed workbook.
Alternative download site:
http://www.download.com/Morefunc/300...-10423159.html -- Biff Microsoft Excel MVP "Tom-S" wrote in message ... 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 "Jim Thomlinson" wrote: 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 |
| All times are GMT +1. The time now is 08:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com