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