How to use INDIRECT?
 

Referring to the post in General Querstion

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

How to use INDIRECT?
 

I responded in excel.misc. You can't INDIRECT into a closed workbook, but
there are alternative solutions.

--
---
HTH

Bob

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



"Eric" wrote in message
...
Referring to the post in General Querstion

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