any way to access data in unopened excel
 

I have two excel files. One file, say a.xls needs to link to some data
from another file b.xls. Is it possible to do so without opening the
file b.xls?


--
chengkithung
------------------------------------------------------------------------
chengkithung's Profile: http://www.excelforum.com/member.php...o&userid=32565
View this thread: http://www.excelforum.com/showthread...hreadid=523621

any way to access data in unopened excel
 

=[OtherFile.xls]Sheet1!$A$1

This formula will bring in the value in the referenced workbook, sheet, and
cell


Vaya con Dios,
Chuck, CABGx3


"chengkithung" wrote:


I have two excel files. One file, say a.xls needs to link to some data
from another file b.xls. Is it possible to do so without opening the
file b.xls?


--
chengkithung
------------------------------------------------------------------------
chengkithung's Profile: http://www.excelforum.com/member.php...o&userid=32565
View this thread: http://www.excelforum.com/showthread...hreadid=523621