J
Jeff Coleman
I'm trying to figure out how to reference the text in a
cell that contains a path to a file to use in a subsequent
formula.
Example:
Assume some file is on server in a directory lets say the
file is called File1.xls
Assume: [File1.xls]!$A$1="Hello World"
In Another workbook...
Let text in A1= "'\\someserver\directory\[File1.xls]'"
Let formula in cell A2= A1$ & "!" & $A$1
Result of formula should be = "Hello World"
I would like to be able to do this without creating a
macro, any help will be greatly appreciated.
Jeff
cell that contains a path to a file to use in a subsequent
formula.
Example:
Assume some file is on server in a directory lets say the
file is called File1.xls
Assume: [File1.xls]!$A$1="Hello World"
In Another workbook...
Let text in A1= "'\\someserver\directory\[File1.xls]'"
Let formula in cell A2= A1$ & "!" & $A$1
Result of formula should be = "Hello World"
I would like to be able to do this without creating a
macro, any help will be greatly appreciated.
Jeff