accessing a cell from another .xls file

  • Thread starter Thread starter Mike s.
  • Start date Start date
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.
 
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.
 
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
 
You must log in or register to reply here.

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

How to Import data from a different .xls file 2
Macro to pull data from another file - update name of file 2
showing cell locations per answer from Ron Coddere - stuck! 1
File save as cell value 6
Unable to open .xls files saved by other users 1
Excel file extension is camouflaged as xls 1
macro-import another xls file 15
Macro to save and close, then copy file 2

Back
Top