Hi,

does anyone know how/if i can include a cell value within a path in a
function/formula so i can update it by simply changing cell value,
e.g.


SUM($A$1, '[E:\folder\stats June.xls]'!sheet1$A$1)

so that the 'June' part can change according to a cell value, say F1.
So if I change F1 from "June" to "July" then the SUM formula would
change to show ....'\stats July' .

many thanks in advance, Nelly