Excel 2003 - Parameterize Workbook Links?
you are correct, it is the same for 2003
"Jon" wrote:
DHL,
I tried using indirect to solve this for one of my spreadsheets, but it only
worked if the second file was open. If it was not open, the data didn't get
pulled in. (I'm using Excel 2000... not sure if 2003 is different)
"bj" wrote:
try
=indirect($B$2&"$A$1)
"DHL" wrote:
I have a link from one workbook to another e.g.
='C:\temp\[Book1.xls]Sheet1'!$A$1
However, I want to parameterize which external workbook to go to, e.g.
in my main workbook I would like to have a cell which contains the location
and name of another workbook and then use the contents of this cell to
dynamically make up my link query.
For example, say I have in cell $B$2 of my main workbook a value of
C:\temp\[Book1.xls]Sheet1
then in cell $B$3 I want to dynamically make a link to this external
workbook, e.g.
=<$B$2!$A$1
This would bring back the contents of cell $A$1 from
C:\temp\[Book1.xls]Sheet1, however, if I then changed the file & location
details in cell $B$2 to, for example, C:\windows\[Workbook.xls]Sheet2, the
dynamic link in cell $B$3 would then bring back the contents of cell $A$1
form C:\windows\[Workbook.xls]Sheet2.
Hope that makes sense. How would I do this?
Many thanks
DHL
|