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