ExcelBanter - INDIRECT.EXT

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - INDIRECT.EXT (https://www.excelbanter.com/excel-discussion-misc-queries/108139-indirect-ext.html)

Kaby

INDIRECT.EXT

This formula:

=INDIRECT.EXT('H:\["&D100&".xls]BUYERSREQUEST'!C44)

keeps giving me a #value error...any obvious reasons....

Andy Wiggins

INDIRECT.EXT

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....

Toppers

INDIRECT.EXT

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....

Andy Wiggins

INDIRECT.EXT

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....

All times are GMT +1. The time now is 07:21 AM.