ExcelBanter - Dynamic directory path

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Dynamic directory path (https://www.excelbanter.com/excel-discussion-misc-queries/84818-dynamic-directory-path.html)

Newbie

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.

Bob Phillips

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.

All times are GMT +1. The time now is 08:22 PM.