accessing a cell from another .xls file
 

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.

accessing a cell from another .xls file
 

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.

---
Per


"Mike s." <Mike skrev i meddelelsen
...
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.

accessing a cell from another .xls file
 

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
"Mike s." <Mike wrote in message
...
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.