Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A question about INDIRECT()
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, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A question about INDIRECT()
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" wrote in message ... 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, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A question about INDIRECT()
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" wrote: 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" wrote in message ... 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, |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A question about INDIRECT()
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" wrote in message ... 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" wrote: 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" wrote in message ... 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, |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A question about INDIRECT()
Thank you Bob!
I tried the INDIRECT.EXT() function today, and it works great. This excel file will be reviewed by somebody, whose PC might not have INDIRECT.EXT() built-in function. Will INDIRECT.EXT() points to the built-in function INDIRECT() when his PC EXCEL does not install INDIRECT.EXT()? Thanks, "Bob Phillips" wrote: 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" wrote in message ... 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, |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A question about INDIRECT()
No - he will get a #NAME error.
One of the pitfalls of using add-ins... In article , Shuang wrote: I tried the INDIRECT.EXT() function today, and it works great. This excel file will be reviewed by somebody, whose PC might not have INDIRECT.EXT() built-in function. Will INDIRECT.EXT() points to the built-in function INDIRECT() when his PC EXCEL does not install INDIRECT.EXT()? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDIRECT Question | Excel Discussion (Misc queries) | |||
INDIRECT Question I think | Excel Discussion (Misc queries) | |||
Indirect question | Excel Discussion (Misc queries) | |||
indirect.ext question | Excel Discussion (Misc queries) | |||
INDIRECT.EXT question | Excel Worksheet Functions |