If in A1 i put

=("'C:\a\Aste\["&(B8)&".xls]"&"Foglio1'!$B$1") (where B8 contains the
filename to open "tmp1.xls")

this returns exactly the path for have the value in file tmp1 cell B1, but
the cell returns the text

'C:\a\Aste\[tmp1.xls]Foglio1'!$B$1


not the value of the file !!

How can I retrive the value?

Tnx
M.

"Mire" ha scritto nel messaggio
...
Hi,
In cell A1 of summary.xls, I need to retrieve the value of cells A1 of the
file with name in cells B1 of summary.xls.

Ex.

In A1 of summary.xls
='C:\[a.xls]Foglio1'!$A$1

I need to insert the namefile in B1 of summary.xls
--- 'C:\[ ** value of cells B1 ** ]Foglio1'!$A$1

Thanks in advance to anyone
M