The INDIRECT.EXT definitely sounds like the best way to go, but…
My IT Department has an antiquated way of thinking and is extremely protective over their realm. They are unwilling to install the Morefunc add-in without extensive testing and won't even consider starting the process until 6 months from now, so…
Is there a comparable UDF or other method that might accomplish the same thing? I realize this would reinvent the wheel but this is my only option right now. The basic problem is I need to access closed files whose filepath includes characters from a defined name.
It would look something like this, where "23" is a defined name that may change and (10-03 Sales logs.xls) is not open:
=IF(FileExists("G:\Zones\Br23\10-03 Sales logs.xls"),IF(ISERROR(V('G:\Zones\Br23\[10-03 Sales logs.xls]Totals'!C$14)),"",V()),"")