indirect function

  • Thread starter Thread starter gozik
  • Start date Start date
G

gozik

I am using the indirect function to read date from several workbooks..
I couldn't find a way to read the data without having the other file
open. I would like to read the data from these files without havin
them open. Please advice
 
Hi
if you only want to get one cell from a different closed workbook you
may have a look at the Add-In MOREFUNC.XLL
(http://longre.free.fr/english)
use the function INDIRECT.EXT.e.g.
=INDIRECT.EXT("''C:\Documents and Settings\" & cell_ref1 & "\My
Documents\My folder\[" & cell_ref2 & cell_ref3 & ".xls]Expense
Statement'!$F$2")
thats is just replace your function INDIRECT with INDIRECT.EXT

you may also have a look at the following thread (describing further
alternatives for accessing closed workbooks): http://tinyurl.com/2c62u

Frank
 
Back
Top