If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to call a reference to a cell in external file
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 |
#2
|
|||
|
|||
how to call a reference to a cell in external file
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/ -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "jose" wrote in message oups.com... 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 |
#3
|
|||
|
|||
how to call a reference to a cell in external file
thank you very much. i used indirect.ext and it worked fine.
cheers, -- jose On Feb 26, 1:37 pm, "Bob Phillips" wrote: You could try Harlan Grove's PULL function. You can get itftp://members.aol.com/hrlngrv/(look for pull.zip) |
Thread Tools | |
Display Modes | |
|
|