Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK? | Excel Worksheet Functions | |||
Possible to copy sheets into another (closed!) workbook? | Excel Discussion (Misc queries) | |||
Unprotect Workbook | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions |