View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mire Mire is offline
external usenet poster
 
Posts: 8
Default retrieve value in file (NO VBA)

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