Question about INDIRECT.EXT

[Justin583]

Can anyone confirm that this is a legitimate add-on? I work for a small company and it may be difficult to implement the INDIRECT.EXT function if the add-on is not legitimate. Here's the site:

http://xcell05.free.fr/english/

 

[Oaktree]

Laurent Longre's morefunc.dll (of which INDIRECT.EXT is part) is likely *THE* most commonly used add-in for Excel. Several senior members of this board had input to its development and debugging. Further, MOREFUNC is one of the recommended add-ins by this board.

 

[Von Pookie]

What do you mean by 'legitimate?' Many, many users here on the board highly recommend the MoreFunc add-in, I can tell you that much.

Edit: Probably also worth mentioning that Laurent Longre (the author of that add-in) is a Microsoft MVP for Excel
https://mvp.support.microsoft.com/profile=12323CE5-3506-4662-BFEF-F436892FAB77

 

[Justin583]

Ok thanks, looks like a great program. Having trouble with the function now. Here is the code that I used with the plain INDIRECT function which works:

=AVERAGE((INDIRECT("'[File Name.xls]Sheet1'!G"&$R4)), (INDIRECT("'[File Name.xls]Sheet1'!M"&$R4)), (INDIRECT("'[File Name.xls]Sheet1'!T"&$R4)))

And here it is with INDIRECT.EXT, which doesn't work:

=AVERAGE((INDIRECT.EXT("'C:\Folder\[File Name.xls]Sheet1'!G"&$R5)), (INDIRECT.EXT("'C:\Folder\[File Name.xls]Sheet1'!M"&$R5)), (INDIRECT.EXT("'C:\Folder\[File Name.xls]Sheet1'!T"&$R5)))

Can the file name have a space in it? It can with INDIRECT.

 

[Justin583]

Nevermind, it works.