referencing other work book using the INDIRECT function

[jC!]

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!

 

[Vasant Nanavati]

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/[email protected]

 

[jurgen C]

hi Vasant,

thanks for your reply and for your advise.

cheers....

....jurgenC!