Thread: INDIRECT.EXT
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike McLellan
 
Posts: n/a
Default 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?