Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Path Reference in cells
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate path and file string for external reference | Excel Worksheet Functions | |||
Cell reference to make a directory path | Excel Worksheet Functions | |||
Keep full file path in cell reference | Excel Discussion (Misc queries) | |||
file path: reference to other workbooks | Excel Worksheet Functions | |||
How to remove path from macro reference | Excel Discussion (Misc queries) |