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
 
G

Guest

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

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


Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cross-reference data from one file to another file 1
How to activate an open worksheet? 7
<Select sheet> window 2
macro required.. 1
Open & update another file (through macro) while running macro 1
how to reference different workbooks/sheets in formula? 1
Transferring Data from Multiple Excel files to single excel files. 2
controling a .xls from another .xls 2

Top