Reading data in onther Excel document
 

How do I read data in another opened excel document (in a certain sheet)
without activating it.


--
Ernest
------------------------------------------------------------------------
Ernest's Profile: http://www.excelforum.com/member.php...o&userid=26584
View this thread: http://www.excelforum.com/showthread...hreadid=398547

By "read" do you mean link it into the active workbook? Use a link formula:

='[Other Book.xls]Sheet1'!$A$1



"Ernest" wrote:


How do I read data in another opened excel document (in a certain sheet)
without activating it.


--
Ernest
------------------------------------------------------------------------
Ernest's Profile: http://www.excelforum.com/member.php...o&userid=26584
View this thread: http://www.excelforum.com/showthread...hreadid=398547