accessing a cell from another .xls file

M

Mike s.

Wonder if anyone can provide the syntax to be able to access the numerical
value of a cell located in an .xls file other than the current one.

Thanks.
 
P

Per Jessen

Hi

=[Book1.XLS]Sheet1!$A$1

Well, in the desired formula cell type an equal sign, then goto "Window",
select the desired workbook, select the desired sheet then the desired cell
and hit Enter. Your formula is now referencing the desired cell.

Hopes this helps.
 
J

John

Hi Mike
Not sure what you need but this is syntax to another workbook,tab "Invoice, cell
A1 ='[INVOICE MultiDbase.xls]Invoice'!$A$1
HTH
John
 
Top