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