Hi Dave.

With find/replace doesn't work.

After replace ("$$$$") A1 appears as:

'C:\a\Aste\[ABA104.xls]Foglio1'!$C$2 -
(=""&("'C:\a\Aste\["&(B8)&".xls]"&"Foglio1'!$C$2"))

and it doesn't retrieve the value :(

Tnx

M.





Build your formula like:

="$$$$"&"'C:\a\Aste\["& B8 &".xls]"&"Foglio1'!$B$1"



Let it/them evaluate to

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

Now select that range of cells and

Edit|Replace

find what: $$$$

replace with: =



And your text strings will be converted to formulas and the formulas will
try to

retrieve that data from the closed workbook. (Typing mistakes are a big
problem

(when it tries to find the "sending" workbook/worksheet). So be careful.)



Mire wrote:



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







--



Dave Peterson