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! :)

Sorry, INDIRECT does not work with closed workbooks. Do a Google Groups
search using "indirect" and "closed" as keywords and you will find some
workarounds, notably by John Walkenbach and Harlan Grove.

--

Vasant



http://google.com/groups?selm=3F5E56...9DB0%40msn.com
"jC!" wrote in message
om...
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! :)

hi Vasant,

thanks for your reply and for your advise.

cheers....

....jurgenC!



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!