any way to access data in unopened excel

C

chengkithung

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

CLR

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

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


Vaya con Dios,
Chuck, CABGx3
 
Top