I see you've posted in another forum.

I'll drop out.

Dave Peterson wrote:

I still don't use =indirect.ext(), but you may want to share what you tried.

In fact, you may want to try to get it working using a string--no references to
other cells at all:

=INDIRECT.ext("[ProgressUpdate_whatisind3here.xls]whatisind3again!D6")
(You really want d3 twice??)

When you get that working, you can try to build your concatenated string.

If you fail, share the string that worked. And share the values that are in D3
and any other cell you used.

Maybe someone who uses =indirect.ext() will be able to help if you give enough
info.

Todd Lietha wrote:

Since INDIRECT() requires that the external workbook is open, are you aware
of another way to build a reference to an external workbook cell without that
workbook being open?

I did try the suggested INDIRECT.EXT, but was not able to make it work. I
was trying to use INDIRECT since that was in an example that I found, but I'd
b e happy to use something else.

"Farhad" wrote:

Hi,

Here is another way:

=INDIRECT("[ProgressUpdate_"&$D$3&".xls]"&$D$3&"!D"&ROW()+5)

assumed you are entering this formula in the first row of your worksheet so
if it is not you have to make sure that you are making the number 6 with
ROW()+5 in your formula at the first row, for example if you are entering
this formula in the row 10 you sould put ROW-4 instead Row()+5 in the formula
above.

Thanks,
--
Farhad Hodjat


"Todd Lietha" wrote:

I need to use a value from a cell to buil a refernce to a cell in another
workbook. I've mostly figured out how to do it using INDIRECT but have hit
one snag.

Current:
=INDIRECT("[ProgressUpdate_"&$D$3&".xls]"&$D$3&"!D6")

where $D$3 contains the value to use in building the reference and D6 is the
cell in the other workbook that I need returned.

But, as I copy this formula down subsequent rows, I need the returned cell
to move down relatively. i.e If the above formula is in row 1 in the local
workbook and returns cell D6, when copy the formula to row 2 I need it to
return cell D7.

How can I do this?

Thanks in advance.

--

Dave Peterson

--

Dave Peterson