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?