Q: There are 2 seperate files....File A and File B. I am trying to extract
data from file A into a cell in file B. The problem is file A's name changes
according to current date e.g. 20060404_A.xls for April 4th and 20060405 for
Apr 5th.

I have used concatenation and it returns "string" that resembles the entry
if file A's name would be constant. I am unable to code the fact that I
require the "value" for that string as a function and not just the string.
E.g. ='D:\My Documents\test\[20060404_A.xls]Analysis'!$C$24' returns the
correct value....But with concatenation when the string returns ='D:\My
Documents\test\[20060405_A.xls]Analysis'!$C$24' (for the NEXT day, check
date) ... I dont get the value just text.

Thanks
Firenzeitl