Reference cells to sub-directories?

[Terry]

I want to reference a cell to a sub-directory. I know how to do it so that:

='C:\WINDOWS\TEMP\green\[0_stats.xls]Extract'!$AA$2

appears in the formula bar when I click on the cell.

However, rather than include "green" in the path, I want Excel to read
"green" from another cell so that the path would be something like:

='C:\WINDOWS\TEMP\A6\[0_stats.xls]Extract'!$AA$2

if cell A6 contains the word "green". Does anyone know the correct syntax
for the A6 in this path? I have looked in books but can't find it anywhere.

Thanks

Terry.

 

[Don Guillett]

Have a look in the help index for INDIRECT but be advised that it will NOT
work on closed workbooks.