Re: access cell in other workbook
- From: "vezerid" <vezerid@xxxxxxx>
- Date: 23 Oct 2006 07:36:40 -0700
You can use INDIRECT, but it requires Workbook B to be open. Sort of
this solution you will need VBA.
=INDIRECT("'[Workbook B]Sheet1'!A1")
This will be updated as soon as Workbook B opens.
HTH
Kostis Vezerides
Glynn Taylor wrote:
I have an array in 'Workbook B'
'Workbook A' contains a cell, say A1, in which I've Calculated a variable
cell reference
How can I obtain the value held in the un-open 'Workbook B' from the cell
defined in 'Workbook A' A1?
Thank you
.
- Prev by Date: Re: Completely baffled on what should be simple
- Next by Date: Re: Why can't name the range?
- Previous by thread: Re: Why can't name the range?
- Next by thread: Re: access cell in other workbook
- Index(es):
