T
Tarra Williams
I am having a problem pulling in data from one excel file
to another...If I select a cell and type in the following
information, it correctly finds the value.
='c:\path\[FileName.xls]Worksheet'!$A$1
What I want to do is be able to change the path in another
cell (say if the data was moved to a different shared area)
and have it so I don't break the referenced link. Since I
have the path hard coded above, it would not update, if
the data was moved.
So, I tried to set a cell = c:\path\ and another cell to
[FileName.xls]Worksheet (I seperated them because the path
should remain the same, but the Excel file being
referenced will change). Then, I combined the two cells by:
=FirstCell & SecondCell
which did pull the two strings together. Using the
ampersand to make the command look like the command that
worked when it was hard coded, doesn't give me the result
I expect. It just prints out the string instead of
recognizing it as an external reference.
Does anyone know how to do this? (hopefully it wasn't too
confusing)
to another...If I select a cell and type in the following
information, it correctly finds the value.
='c:\path\[FileName.xls]Worksheet'!$A$1
What I want to do is be able to change the path in another
cell (say if the data was moved to a different shared area)
and have it so I don't break the referenced link. Since I
have the path hard coded above, it would not update, if
the data was moved.
So, I tried to set a cell = c:\path\ and another cell to
[FileName.xls]Worksheet (I seperated them because the path
should remain the same, but the Excel file being
referenced will change). Then, I combined the two cells by:
=FirstCell & SecondCell
which did pull the two strings together. Using the
ampersand to make the command look like the command that
worked when it was hard coded, doesn't give me the result
I expect. It just prints out the string instead of
recognizing it as an external reference.
Does anyone know how to do this? (hopefully it wasn't too
confusing)