Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Does anyone have any suggestions on how to do it in excel?
In cell A1, there is a text "0001", In cell B1, there is a filing structure ='E:\directory\0001\[file.xls]sheet1'!M14 I would like to insert any 4-digit code into filing structure for receiving value. If I type in "0005" in cell A1, then the directory will return in cell B1. ='E:\directory\0005\[file.xls]sheet1'!M14 Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Use the INDIRECT function.
Perhaps =INDIRECT("'E:\directory\"&A1&"\[file.xls]sheet1'!M14") -- David Biddulph "Eric" wrote in message ... Does anyone have any suggestions on how to do it in excel? In cell A1, there is a text "0001", In cell B1, there is a filing structure ='E:\directory\0001\[file.xls]sheet1'!M14 I would like to insert any 4-digit code into filing structure for receiving value. If I type in "0005" in cell A1, then the directory will return in cell B1. ='E:\directory\0005\[file.xls]sheet1'!M14 Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
.... but remember that INDIRECT only works with files that are open, so in
that case the path may be largely irrelevant. If the file isn't open, you may need the morefunc add-in and INDIRECT.EXT http://xcell05.free.fr/morefunc/english/ -- David Biddulph "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Use the INDIRECT function. Perhaps =INDIRECT("'E:\directory\"&A1&"\[file.xls]sheet1'!M14") -- David Biddulph "Eric" wrote in message ... Does anyone have any suggestions on how to do it in excel? In cell A1, there is a text "0001", In cell B1, there is a filing structure ='E:\directory\0001\[file.xls]sheet1'!M14 I would like to insert any 4-digit code into filing structure for receiving value. If I type in "0005" in cell A1, then the directory will return in cell B1. ='E:\directory\0005\[file.xls]sheet1'!M14 Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
About the morefunc add-in and INDIRECT.EXT,
the page you have requested cannot be found or is no longer available. Do you have any suggestions on where to download this ext? Thank you very much for any suggestions Eric "David Biddulph" wrote: .... but remember that INDIRECT only works with files that are open, so in that case the path may be largely irrelevant. If the file isn't open, you may need the morefunc add-in and INDIRECT.EXT http://xcell05.free.fr/morefunc/english/ -- David Biddulph "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Use the INDIRECT function. Perhaps =INDIRECT("'E:\directory\"&A1&"\[file.xls]sheet1'!M14") -- David Biddulph "Eric" wrote in message ... Does anyone have any suggestions on how to do it in excel? In cell A1, there is a text "0001", In cell B1, there is a filing structure ='E:\directory\0001\[file.xls]sheet1'!M14 I would like to insert any 4-digit code into filing structure for receiving value. If I type in "0005" in cell A1, then the directory will return in cell B1. ='E:\directory\0005\[file.xls]sheet1'!M14 Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I was able to open the page so I don't think there is a problem with the site.
-- Regards, OssieMac "Eric" wrote: About the morefunc add-in and INDIRECT.EXT, the page you have requested cannot be found or is no longer available. Do you have any suggestions on where to download this ext? Thank you very much for any suggestions Eric "David Biddulph" wrote: .... but remember that INDIRECT only works with files that are open, so in that case the path may be largely irrelevant. If the file isn't open, you may need the morefunc add-in and INDIRECT.EXT http://xcell05.free.fr/morefunc/english/ -- David Biddulph "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Use the INDIRECT function. Perhaps =INDIRECT("'E:\directory\"&A1&"\[file.xls]sheet1'!M14") -- David Biddulph "Eric" wrote in message ... Does anyone have any suggestions on how to do it in excel? In cell A1, there is a text "0001", In cell B1, there is a filing structure ='E:\directory\0001\[file.xls]sheet1'!M14 I would like to insert any 4-digit code into filing structure for receiving value. If I type in "0005" in cell A1, then the directory will return in cell B1. ='E:\directory\0005\[file.xls]sheet1'!M14 Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I find the following extension for download, do you find the same link?
INDIRECT.EXT - same as INDIRECT working also with closed workbooks http://xcell05.free.fr/morefunc/engl...direct.ext.htm Once I click on this link, it returns "Page not found". Could you please provide the link for download? Thank everyone very much for any suggestions Eric "OssieMac" wrote: I was able to open the page so I don't think there is a problem with the site. -- Regards, OssieMac "Eric" wrote: About the morefunc add-in and INDIRECT.EXT, the page you have requested cannot be found or is no longer available. Do you have any suggestions on where to download this ext? Thank you very much for any suggestions Eric "David Biddulph" wrote: .... but remember that INDIRECT only works with files that are open, so in that case the path may be largely irrelevant. If the file isn't open, you may need the morefunc add-in and INDIRECT.EXT http://xcell05.free.fr/morefunc/english/ -- David Biddulph "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Use the INDIRECT function. Perhaps =INDIRECT("'E:\directory\"&A1&"\[file.xls]sheet1'!M14") -- David Biddulph "Eric" wrote in message ... Does anyone have any suggestions on how to do it in excel? In cell A1, there is a text "0001", In cell B1, there is a filing structure ='E:\directory\0001\[file.xls]sheet1'!M14 I would like to insert any 4-digit code into filing structure for receiving value. If I type in "0005" in cell A1, then the directory will return in cell B1. ='E:\directory\0005\[file.xls]sheet1'!M14 Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
There are many alternate download sites. Just do a Google search on
Morefunc. -- Biff Microsoft Excel MVP "Eric" wrote in message ... I find the following extension for download, do you find the same link? INDIRECT.EXT - same as INDIRECT working also with closed workbooks http://xcell05.free.fr/morefunc/engl...direct.ext.htm Once I click on this link, it returns "Page not found". Could you please provide the link for download? Thank everyone very much for any suggestions Eric "OssieMac" wrote: I was able to open the page so I don't think there is a problem with the site. -- Regards, OssieMac "Eric" wrote: About the morefunc add-in and INDIRECT.EXT, the page you have requested cannot be found or is no longer available. Do you have any suggestions on where to download this ext? Thank you very much for any suggestions Eric "David Biddulph" wrote: .... but remember that INDIRECT only works with files that are open, so in that case the path may be largely irrelevant. If the file isn't open, you may need the morefunc add-in and INDIRECT.EXT http://xcell05.free.fr/morefunc/english/ -- David Biddulph "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Use the INDIRECT function. Perhaps =INDIRECT("'E:\directory\"&A1&"\[file.xls]sheet1'!M14") -- David Biddulph "Eric" wrote in message ... Does anyone have any suggestions on how to do it in excel? In cell A1, there is a text "0001", In cell B1, there is a filing structure ='E:\directory\0001\[file.xls]sheet1'!M14 I would like to insert any 4-digit code into filing structure for receiving value. If I type in "0005" in cell A1, then the directory will return in cell B1. ='E:\directory\0005\[file.xls]sheet1'!M14 Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|