| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic directory path
Hi All,
Please consider the following path: c:\2006\april\figures.xls I have another sheet that has 'April' in a cell. I want to build this cell reference into the path. I've tried ='c\2006\&"b1"&\figures.xls!sheet1!a1 but doesn't work!! Grateful for any help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dynamic directory path
="'c\2006\"&B1&"\figures.xls!sheet1!a1"
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Newbie" wrote in message ... Hi All, Please consider the following path: c:\2006\april\figures.xls I have another sheet that has 'April' in a cell. I want to build this cell reference into the path. I've tried ='c\2006\&"b1"&\figures.xls!sheet1!a1 but doesn't work!! Grateful for any help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Target directory & Path | Excel Worksheet Functions | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Making path of linked cell dynamic | Excel Discussion (Misc queries) | |||
| auto file path update when excel sheet moved to another directory. | Excel Discussion (Misc queries) | |||
| How do I insert the directory path in my Excel file? | Excel Worksheet Functions | |||
Linear Mode
