ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Value from a closed workbook (https://www.excelbanter.com/excel-discussion-misc-queries/26290-value-closed-workbook.html)

Anthony Slater

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

Ron de Bruin

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 de Bruin

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






Anthony Slater

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 de Bruin

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







Anthony Slater

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