Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Indirect.ext - Eek! Doesn't Work
Hi...
In cell a2 in a new workbook I have the following text string/path: C:\Desktop\Raw\hammer.xls In cell b2 I want the value from a cell within this file - sheet1 j12, without opening the said file. Is there a fast way to do this or should I leave it my kids in my will? I had hoped to seed the first row and the fill down? This file is 100 rows down by 35 columns wide. The indirect.ext refers to the cell rather than the text contents which is grim. Any help would be greatly appreciated. Gordon... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Indirect.ext - Eek! Doesn't Work
I believe you need something like this
=INDIRECT.EXT('C:\Desktop\Raw\[hammer.xls]Sheet1'!j12) "Gordon" wrote: Hi... In cell a2 in a new workbook I have the following text string/path: C:\Desktop\Raw\hammer.xls In cell b2 I want the value from a cell within this file - sheet1 j12, without opening the said file. Is there a fast way to do this or should I leave it my kids in my will? I had hoped to seed the first row and the fill down? This file is 100 rows down by 35 columns wide. The indirect.ext refers to the cell rather than the text contents which is grim. Any help would be greatly appreciated. Gordon... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Indirect.ext - Eek! Doesn't Work
Hi Barb...
Thanks for that. How can I create that very formula without having to type the path for each file. I want the cell in b2 to read the path in a1 and insert it automatically...somehow! Any further help useful... Thanks Gordon... "Barb Reinhardt" wrote: I believe you need something like this =INDIRECT.EXT('C:\Desktop\Raw\[hammer.xls]Sheet1'!j12) "Gordon" wrote: Hi... In cell a2 in a new workbook I have the following text string/path: C:\Desktop\Raw\hammer.xls In cell b2 I want the value from a cell within this file - sheet1 j12, without opening the said file. Is there a fast way to do this or should I leave it my kids in my will? I had hoped to seed the first row and the fill down? This file is 100 rows down by 35 columns wide. The indirect.ext refers to the cell rather than the text contents which is grim. Any help would be greatly appreciated. Gordon... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Indirect.ext - Eek! Doesn't Work
Gordon
Maybe enter something like this in B2: =INDIRECT.EXT("'" & A1 & "'Sheet1'!j12") And then enter your path in A1. I hope this is what you are looking for. Conan Kelly "Gordon" wrote in message ... Hi Barb... Thanks for that. How can I create that very formula without having to type the path for each file. I want the cell in b2 to read the path in a1 and insert it automatically...somehow! Any further help useful... Thanks Gordon... "Barb Reinhardt" wrote: I believe you need something like this =INDIRECT.EXT('C:\Desktop\Raw\[hammer.xls]Sheet1'!j12) "Gordon" wrote: Hi... In cell a2 in a new workbook I have the following text string/path: C:\Desktop\Raw\hammer.xls In cell b2 I want the value from a cell within this file - sheet1 j12, without opening the said file. Is there a fast way to do this or should I leave it my kids in my will? I had hoped to seed the first row and the fill down? This file is 100 rows down by 35 columns wide. The indirect.ext refers to the cell rather than the text contents which is grim. Any help would be greatly appreciated. Gordon... |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Indirect.ext - Eek! Doesn't Work
The problems that I've run into with this is that I forget the single quote
or the [] around the workbook name. Be aware of that. "Gordon" wrote: Hi Barb... Thanks for that. How can I create that very formula without having to type the path for each file. I want the cell in b2 to read the path in a1 and insert it automatically...somehow! Any further help useful... Thanks Gordon... "Barb Reinhardt" wrote: I believe you need something like this =INDIRECT.EXT('C:\Desktop\Raw\[hammer.xls]Sheet1'!j12) "Gordon" wrote: Hi... In cell a2 in a new workbook I have the following text string/path: C:\Desktop\Raw\hammer.xls In cell b2 I want the value from a cell within this file - sheet1 j12, without opening the said file. Is there a fast way to do this or should I leave it my kids in my will? I had hoped to seed the first row and the fill down? This file is 100 rows down by 35 columns wide. The indirect.ext refers to the cell rather than the text contents which is grim. Any help would be greatly appreciated. Gordon... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indirect.ext doesn't work when sent to someone without morefunc ad | Excel Worksheet Functions | |||
Thinking that indirect should work | Excel Discussion (Misc queries) | |||
Indirect - Why does it seem to only work sometimes? | Excel Worksheet Functions | |||
Evaluate(Indirect) doesnt work | Excel Programming | |||
referencing other work book using the INDIRECT function | Excel Programming |