Ron
Thanks ever so much...I understood now and I'm using your solution..
"Ron de Bruin" wrote:
Hi Anthony
For a few cells you can manual enter a formula like this
='C:\Documents and Settings\Ron\Desktop\[Numeric tab.xls]Sheet1'!$A$16
For more see
http://www.rondebruin.nl/copy3.htm
Or
http://www.rondebruin.nl/summary2.htm
Or
http://www.rondebruin.nl/ado.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Anthony Slater" wrote in message
...
Hi Ron
Thanks for the reply but to be honest, I got a bit lost. What macro do I use
and how?
"Ron de Bruin" wrote:
Hi Anthony
I have examples on my site
http://www.rondebruin.nl/tips.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Anthony Slater" wrote in message
...
Hi
How can I extract a value from a closed workbook?
I've tried with the 'Indirect' function but have since learnt that this
doesn't work when the wookbook is closed
i need something like
A1="C:\folder\<filename
TIA