Links

[Alicia]

I am linking several files into one workbook. Is it
possible to reference a cell with the file name into the
link and actually link to that file? For example:

A1=1034 B1=C:\My Documents\["A1".xls]Sheet1!R13

A2=1035 B1=C:\My Documents\["A2".xls]Sheet1!R13

I know I can Concatenate text to mirror my link but I
can't convert the text string to read the formula.

Thanks,
Alicia

 

[Kevin Stecyk]

Alicia,

=INDIRECT("'My Documents\["&A1&".xls]Sheet1'!R3")

You have to be careful to insert double quote, single quote after the
opening bracket, and then a single quote before the !. The other double
quote marks are easier to see.

Hope that helps.

Regards,
Kevin

 

[Kevin Stecyk]

=INDIRECT("'My Documents\["&A1&".xls]Sheet1'!R13")

R13 not R3

Alicia,

=INDIRECT("'My Documents\["&A1&".xls]Sheet1'!R3")

You have to be careful to insert double quote, single quote after the
opening bracket, and then a single quote before the !. The other double
quote marks are easier to see.

Hope that helps.

Regards,
Kevin

I am linking several files into one workbook. Is it
possible to reference a cell with the file name into the
link and actually link to that file? For example:

A1=1034 B1=C:\My Documents\["A1".xls]Sheet1!R13

A2=1035 B1=C:\My Documents\["A2".xls]Sheet1!R13

I know I can Concatenate text to mirror my link but I
can't convert the text string to read the formula.

Thanks,
Alicia

 

[Harlan Grove]

I am linking several files into one workbook. Is it
possible to reference a cell with the file name into the
link and actually link to that file? For example:

A1=1034 B1=C:\My Documents\["A1".xls]Sheet1!R13

A2=1035 B1=C:\My Documents\["A2".xls]Sheet1!R13

I know I can Concatenate text to mirror my link but I
can't convert the text string to read the formula.

If these other files are all going to be open in memory, you've already been
given the answer: use the INDIRECT function. If some or all of these other files
may be closed, INDIRECT won't work. In that case, see

http://www.google.com/[email protected]