INDIRECT.EXT reference

[Guest]

I am trying to use the INDIRECT.EXT function to gather data from closed
files. I am also trying to create a filename reference using the CONCATENATE
function. I am using the CONCATENATE function to create the filename because
of a variable in the name.

The INDIRECT.EXT function is working fine when I use the file pathname
directly (without refering to a concatenated filename in another cell). For
example, it works fine in the following:

=INDIRECT.EXT("'C:\Folder\[FilenameABC.xls]Sheet1'!$B$1")

But when I create the same filename using the CONCATENATE function and refer
to the concatenated cell it is not working.

I am creating the concatenated filename using the following formula in, say,
cell A10

=CONCATENATE("'C:\Folder\[Filename",F2,".xls]Sheet1!$B$1")

Where F2 contains the part of the filename that is a variable.

Then I am trying to use the INDIRECT.EXT function by refering to cell A10:

INDIRECT.EXT(A10)

This is not working for me. Does anyone see the problem with this approach??

Thanks!!!

 

[Guest]

try this
F2 should be ABC

=INDIRECT("'C:\folder\["&F2&".xls]Sheet1'!$G$14")