| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Indirect to a closed workbook
Hi,
I use this to get values from another workbook =INDIRECT("'[Projects.xls]" & B7 & "'!D" & J2) which works fine if the workbook [Projects.xls] is open. The problem is I want to have the workbook [Project.xls] closed. Any sugestion thanks MarkS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use of the Indirect function on a closed workbook. | Excel Discussion (Misc queries) | |||
| Indirect referencing closed spreadsheets | Excel Discussion (Misc queries) | |||
| INDIRECT should be updated to work on closed workbooks. | Excel Worksheet Functions | |||
| How do I use indirect when referring to a named range in a closed | Excel Worksheet Functions | |||
| INDIRECT and Named Ranges referencing closed workbook | Excel Worksheet Functions | |||
Threaded Mode
