How to use INDIRECT?

[Guest]

If I get a link ='D:\windows\excel\[DATA.xls]XYZ'!$H$2, then
I would like to insert the variable XYZ into cell A1.
Does anyone have any suggestions on how to use INDIRECT function to create a
link?
Can I do something like below? but I try it, which don't work!
=INDIRECT('D:\windows\excel\[DATA.xls]&A1&'!$H$2)
Does anyone have any suggestions?
Thank you in advance
Eric

 

[Bob Phillips]

http://makeashorterlink.com/?F2993260A

You could try Harlan Grove's PULL function. You can get it
ftp://members.aol.com/hrlngrv/ (look for pull.zip)

You would use it like so

=pull("'"&A3&"\["&B3&".xls]"&C3&"'!"&"B5")

or

=pull("'"&A3&"\["&B3&".xls]"&C3&"'!B5")

Alternative

As for alternatives, try the INDIRECT.EXT function in Laurent Longre's
MOREFUNC.XLL add-in, available from


http://xcell05.free.fr/english/


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)