INDIRECT.EXT reference

P

pdabill

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top