INDIRECT.EXT

M

Mike McLellan

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?
 
H

Haldun Alay

http://xcell05.free.fr/english/index.html#Morefunc_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" <[email protected]>, haber iletisinde ÅŸunları yazdı:D[email protected]...
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top