| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate path and file string for external reference
I am trying to create a linked external reference by concatinating the
info together. I have in 3 cells: path file sheet H:\Dev\ [fromModel.xls] Sheet1'!$B4 I concat them to create what should be the reference ='H:\Dev\[fromModel.xls]Sheet1'!$B4 But it just returns the string. How do I get it to evaluate? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keep full file path in cell reference | Excel Discussion (Misc queries) | |||
| Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
| File path of external link changed | Links and Linking in Excel | |||
| file path: reference to other workbooks | Excel Worksheet Functions | |||
| How do I reference external data from a file, file name found in . | Excel Discussion (Misc queries) | |||
![Michael[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
