Oops ... I saw INDIRECT not INDIRECT.EXT :-(
--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-
"Toppers" wrote in message
...
Try:
=INDIRECT.EXT("'H:\["&D100&".xls]BUYERSREQUEST'!C44")
and workbook can be closed.
HTH
"Andy Wiggins" wrote:
The source workbook has to be open.
--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-
"Kaby" wrote in message
...
This formula:
=INDIRECT.EXT('H:\["&D100&".xls]BUYERSREQUEST'!C44)
keeps giving me a #value error...any obvious reasons....