| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDIRECT.EXT
I am trying to access data in a closed file using the add in INDIRECT.EXT.
The name of the file is in C11 (value = "'C:\Temp\20060327\[20060327 - Weekly - All locations - LPS - Live.xls]Weekly'!$C$9" inc double quotes) and the call to INDIRECT.EXT (value = =INDIRECT.EXT(C11)) is in F11. The result of the call is a #VALUE! error. When I change the call in F11 to =INDIRECT.EXT("'C:\Temp\20060327\[20060327 - Weekly - All locations - LPS - Live.xls]Weekly'!$C$9") it works a treat. Can anyone explain what's wrong with the former expression? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INDIRECT.EXT Help Required | Excel Worksheet Functions | |||
| Problems with PULL function, INDIRECT.EXT and so forth | Excel Worksheet Functions | |||
| Data from closed workbooks (pull func, indirect.ext, etc ....) | Excel Worksheet Functions | |||
| INDIRECT.EXT question | Excel Worksheet Functions | |||
| Problem with updating values with INDIRECT.EXT | Excel Worksheet Functions | |||
Threaded Mode
