Value from a closed workbook
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 |
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 |
For a few cells use a formula like this
='C:\Documents and Settings\Ron\Desktop\[Numeric tab.xls]Sheet1'!$A$16 -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... 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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 05:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com