Value from a closed workbook

G

Guest

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
 
R

Ron de Bruin

For a few cells use a formula like this
='C:\Documents and Settings\Ron\Desktop\[Numeric tab.xls]Sheet1'!$A$16
 
G

Guest

Hi Ron

Thanks for the reply but to be honest, I got a bit lost. What macro do I use
and how?
 
G

Guest

Ron

Thanks ever so much...I understood now and I'm using your solution..



Ron de Bruin said:
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 said:
Hi Ron

Thanks for the reply but to be honest, I got a bit lost. What macro do I use
and how?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top