Hello Experts,

I have a cell which contains a string e.g.

"C:\Documents and Settings\Shreepad\Desktop\[Book2.xls]Sheet1'!$D$10"

How do i get excel to evaluate the above string so that it will get me the value in the cell D10 from mentioned file?

(I will get this string buy adding two strings)

Thanks in advance for your help.

Regards

Shree