How can I replace the path of the linked spreadsheet in a cell?
I have a spredsheet that is intended to gather information from another
spreadsheet. So I have linked the cells. The problem is that for each new
project the linked file is the same name, but in a different folder.
I have an if statement in a cell like the one below.
=IF(BoltEdgeDist=-2147483648,'C:\TeklaStructuresModels\[jointdefaults.xls]Defaults'!$C$21,BoltEdgeDist/25.4)
I need to be able to change "'C:\TeklaStructuresModels" to the current
folder. I am collecting the name of the current folder in a cell but I am
not able to replace "'C:\TeklaStructuresModels" with the cell or range name.
Is this possible?
|