indirect external reference

[batmaing]

Hello,

I'm not sure if the subject title is completely correct but here is what I'm trying to accomplish. Instead of referencing another workbook like so:

='[another.xls]RAW'!$A$1

I'd like to put another.xls in a cell, let's say cell B2 and reference it like this:

='["&B2&"]RAW'!$A$1

I think I'm close but I'm missing a little something. Eh.

Thanks in advance!
batmaing
This message was edited by batmaing on 2002-09-16 12:36

 

[Aladin Akyurek]

On 2002-09-16 12:35, batmaing wrote:
Hello,

I'm not sure if the subject title is completely correct but here is what I'm trying to accomplish. Instead of referencing another workbook like so:

='[another.xls]RAW'!$A$1

I'd like to put another.xls in a cell, let's say cell B2 and reference it like this:

='["&B2&"]RAW'!$A$1

I think I'm close but I'm missing a little something. Eh.

Thanks in advance!
batmaing
This message was edited by batmaing on 2002-09-16 12:36

=INDIRECT("'["&B2&"]RAW'!$A$1")

This requires that the target file is open during processing.