Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to add formula calling up current workbook when sheet copied | Excel Discussion (Misc queries) | |||
Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
Calling macros in another workbook | Excel Worksheet Functions | |||
Calling another workbook not working | Excel Worksheet Functions | |||
Issuing macro in workbook from separate workbook | Excel Discussion (Misc queries) |