| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I automatically open linked documents in Excel? | New Users to Excel | |||
| replace absolute references | Excel Worksheet Functions | |||
| Replace worksheet name in formula linked to a different workbook | Excel Discussion (Misc queries) | |||
| Automation of Path of linked tables | New Users to Excel | |||
| Copy and Paste Formula Without the linked file path | Excel Worksheet Functions | |||
Threaded Mode
