how to call a reference to a cell in external file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jose - 26 Feb 2007 10:59 GMT

Hello guys,

is it possible to get a behaviour like this in Excel?

A1 contains a text value ='C:\[file.xls]List1'!D51 (not a formula!)
A2 contains a reference to A1 so that it actually displays D51 in
external file.xls

I thought INDIRECT would be my choice but it does not work with
external files.

Any ideas?

Cheers,

-- joe

Reply to this Message

Bob Phillips - 26 Feb 2007 12:37 GMT

You could try Harlan Grove's PULL function. You can get it
ftp://members.aol.com/hrlngrv/ (look for pull.zip)

You would use it like so

=pull("'"&A3&"\["&B3&".xls]"&C3&"'!"&"B5")

or

=pull("'"&A3&"\["&B3&".xls]"&C3&"'!B5")

Alternative

As for alternatives, try the INDIRECT.EXT function in Laurent Longre's
MOREFUNC.XLL add-in, available from

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

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Hello guys,
>
[quoted text clipped - 12 lines]
>
> -- joe

Reply to this Message

jose - 27 Feb 2007 09:59 GMT

thank you very much. i used indirect.ext and it worked fine.

cheers,

-- jose

> You could try Harlan Grove's PULL function. You can get itftp://members.aol.com/hrlngrv/(look for pull.zip)

Reply to this Message