Indirect.ext - Eek! Doesn't Work

[Guest]

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

 

[Guest]

I believe you need something like this

=INDIRECT.EXT('C:\Desktop\Raw\[hammer.xls]Sheet1'!j12)

 

[Guest]

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

I believe you need something like this

=INDIRECT.EXT('C:\Desktop\Raw\[hammer.xls]Sheet1'!j12)

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

 

[Conan Kelly]

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

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

I believe you need something like this

=INDIRECT.EXT('C:\Desktop\Raw\[hammer.xls]Sheet1'!j12)

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

 

[Guest]

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.

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

I believe you need something like this

=INDIRECT.EXT('C:\Desktop\Raw\[hammer.xls]Sheet1'!j12)

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