Links

  • Thread starter Thread starter Alicia
  • Start date Start date
A

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
 
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
 
=INDIRECT("'My Documents\["&A1&".xls]Sheet1'!R13")

R13 not R3


Kevin Stecyk said:
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



Alicia said:
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
Click to expand...
Click to expand...
 
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.
Click to expand...

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]
 
Back
Top