Dynamic directory path

N

Newbie

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.
 
B

Bob Phillips

="'c\2006\"&B1&"\figures.xls!sheet1!a1"


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top