I am trying to build a database which will contain data from various other
workbooks. I used Indirect function to create the same, which apparently has
a limitation that it will work only when the external workbook is open. Are
there any ways to work around this - i.e. any other changes to the formula or
any other formulas? I use concatenate to combine various other fields in the
database to create a file name, sheet name and cell reference which will then
be combined with indirect to return values from the external workbook

Does this thread point you in the right direction:

http://tinyurl.com/lbzho
?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Suresh" wrote in message
...
I am trying to build a database which will contain data from various other
workbooks. I used Indirect function to create the same, which apparently
has
a limitation that it will work only when the external workbook is open.
Are
there any ways to work around this - i.e. any other changes to the formula
or
any other formulas? I use concatenate to combine various other fields in
the
database to create a file name, sheet name and cell reference which will
then
be combined with indirect to return values from the external workbook