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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDIRECT.EXT
http://xcell05.free.fr/english/index...func_Functions I think you are using MOREFUNC add-in for INDIRECT.EXT If so, remove the double quotes from C11. and replace the formula with INDIRECT(CONCATENATE("'",C11)). it worked for me. ' character has a special meaning for excel. if a cell content starts with ' character, excel assumes rest of the cell content as text. beacuse of that we used CONCANTENATE to add ' char to C11 cell content in INDIRECT.EXT formula. -- Haldun Alay "Mike McLellan" , haber iletisinde şunları ... 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDIRECT.EXT
Haldun,
Many thanks - worked a treat:-D Mike "Haldun Alay" wrote: http://xcell05.free.fr/english/index...func_Functions I think you are using MOREFUNC add-in for INDIRECT.EXT If so, remove the double quotes from C11. and replace the formula with INDIRECT(CONCATENATE("'",C11)). it worked for me. ' character has a special meaning for excel. if a cell content starts with ' character, excel assumes rest of the cell content as text. beacuse of that we used CONCANTENATE to add ' char to C11 cell content in INDIRECT.EXT formula. -- Haldun Alay "Mike McLellan" , haber iletisinde şunları ... 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? |
Reply |
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 |