| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP from closed file using INDIRECT function | Excel Worksheet Functions | |||
| INDIRECT function do not work when other file is closed | Excel Discussion (Misc queries) | |||
| INDIRECT and Named Ranges referencing closed workbook | Excel Worksheet Functions | |||
| Use INDIRECT function to reference a value in closed file | Excel Worksheet Functions | |||
| Indirect( ) function loosing values when spreadsheets are closed | Excel Worksheet Functions | |||
Linear Mode
