INDIRECT() calling a separate workbook
 

I link several documents using the INDIRECT() function dynamically selecting
which XLS file to open based on internal parameters. While this solution is
super effective, it requires that the target file (the one pointed by the
INDIRECT() function) is already opened to avoid a REF# error.

I was wondering if there is a smart, and automated way to open several files
before using them so that the INDIRECT() function can effectively retrieve a
value in the desired cell. In other words, is there a simple way to open
several files simultaneously so that all the required data are accessible
when needed?

Thanks, Stefano

INDIRECT() calling a separate workbook
 

Sub UpdateStockFiles()
Workbooks.Open FileName:="C:\folder\xxxfile1.xls"
Workbooks.Open FileName:="C:\folder\aaafile2.xls"
Workbooks.Open FileName:="C:\folder\fkkkile3.xls"
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"smaruzzi" wrote in message
...
I link several documents using the INDIRECT() function dynamically
selecting
which XLS file to open based on internal parameters. While this solution
is
super effective, it requires that the target file (the one pointed by the
INDIRECT() function) is already opened to avoid a REF# error.

I was wondering if there is a smart, and automated way to open several
files
before using them so that the INDIRECT() function can effectively retrieve
a
value in the desired cell. In other words, is there a simple way to open
several files simultaneously so that all the required data are accessible
when needed?

Thanks, Stefano