A question about INDIRECT()

S

Shuang

A workseet contains a lot of INDIRECT() functions, each INDIRECT() function
contains a link to another EXCEL file. Seems other EXCEL files should be
open, otherwise, reference error occurs. Because there are many other EXCEL
files, it is uncomfortable to open many EXCEL windows.

Are there any ways to use this kind of INDIRECT functions without opening
other
files?

Thanks,
 
B

Bob Phillips

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")

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)
 
T

Todd Lietha

I have the very same situation and need as Shaung. I've installed
INDIRECT.EXT, but am experiencing issues with it, so would liek to try PULL.
I was blocked from accessing the site to retrieve the PULL function that you
mentioned. Do I need to be an AOL member to access that site?

Any other suggestions would be greatly appreciated!

Bob Phillips said:
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")

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)



Shuang said:
A workseet contains a lot of INDIRECT() functions, each INDIRECT() function
contains a link to another EXCEL file. Seems other EXCEL files should be
open, otherwise, reference error occurs. Because there are many other
EXCEL
files, it is uncomfortable to open many EXCEL windows.

Are there any ways to use this kind of INDIRECT functions without opening
other
files?

Thanks,
Click to expand...
Click to expand...
 
P

Peo Sjoblom

No, I just tried it, it is still there and can be downloaded. Btw, what
issues are you having with INDIRECT.EXT?


--

Regards,

Peo Sjoblom




Todd Lietha said:
I have the very same situation and need as Shaung. I've installed
INDIRECT.EXT, but am experiencing issues with it, so would liek to try
PULL.
I was blocked from accessing the site to retrieve the PULL function that
you
mentioned. Do I need to be an AOL member to access that site?

Any other suggestions would be greatly appreciated!

Bob Phillips said:
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")

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)



Shuang said:
A workseet contains a lot of INDIRECT() functions, each INDIRECT()
function
contains a link to another EXCEL file. Seems other EXCEL files should
be
open, otherwise, reference error occurs. Because there are many other
EXCEL
files, it is uncomfortable to open many EXCEL windows.

Are there any ways to use this kind of INDIRECT functions without
opening
other
files?

Thanks,
Click to expand...
Click to expand...
Click to expand...
 
Top