let's say i have this formula which works

='N:\My Documents\Excel\Test.xls'!Feb_Profit

if Test is in c1, how would i write the formula using indirect?

i tried
=INDIRECT("'N:\My Documents\' "& C1 & ".xls'!Feb_Profit")
and
=INDIRECT("'N:\My Documents\Excel\"& C1 & ".xls'!Feb_Profit")

but get a ref error

--


Gary

You wouldn't because, as it explains in help on INDIRECT, INDIRECT does not
work with links to closed workbooks.

--
Regards,
Tom Ogilvy



"Gary Keramidas" wrote:

let's say i have this formula which works

='N:\My Documents\Excel\Test.xls'!Feb_Profit

if Test is in c1, how would i write the formula using indirect?

i tried
=INDIRECT("'N:\My Documents\' "& C1 & ".xls'!Feb_Profit")
and
=INDIRECT("'N:\My Documents\Excel\"& C1 & ".xls'!Feb_Profit")

but get a ref error

--


Gary

ok, thanks, that explains it

--


Gary


"Tom Ogilvy" wrote in message
...
You wouldn't because, as it explains in help on INDIRECT, INDIRECT does not
work with links to closed workbooks.

--
Regards,
Tom Ogilvy



"Gary Keramidas" wrote:

let's say i have this formula which works

='N:\My Documents\Excel\Test.xls'!Feb_Profit

if Test is in c1, how would i write the formula using indirect?

i tried
=INDIRECT("'N:\My Documents\' "& C1 & ".xls'!Feb_Profit")
and
=INDIRECT("'N:\My Documents\Excel\"& C1 & ".xls'!Feb_Profit")

but get a ref error

--


Gary