hi all,

hope someone can help on following:

trying to use the INDIRECT function within Excel 2003 to refer to an
other closed work book and i receive an #REF! error - i go as follow =

if
B1 ='C:\Documents and Settings\TestPlan\[Reports.xls]TestScripts'!F4
this will give me 294 as a result (the value in the respective cell,
which is correct)

however if
B1 =INDIRECT("'C:\Documents and
Settings\TestPlan\[Reports.xls]TestScripts'!F4")
this will give me a #REF! error

i tried adding the ~symbol to the 'quotes, but to no avail

any help is mostly appreciated and thanks in advance

cheers...

.....jurgenC! :)