| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
How to interpret a path to another workbook and use in formula bar
Hi
How can I add values from a sheet in another workbook without hardcoding the path in the formula e.g: ='F:\[January_04.xls]Sheet1'!$L$92 + L91 What I would like is to let the user select the workbook to pull values from, by typing the path into another cell. I can do with vba but its longwinded, is there a way to interpret the path from another cell? Thanks hals_left |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
| Workbook path | Excel Discussion (Misc queries) | |||
| How to interpret cell references from formula to vba? | Excel Programming | |||
| path of workbook | Excel Programming | |||
| Workbook Path | Excel Programming | |||
Threaded Mode
