Dynamic directory path

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

[Bob Phillips]

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


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Newbie" <[email protected]> wrote in message
news:[email protected]...
> 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.
>