Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How to do it in excel?

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default How to do it in excel?

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default How to do it in excel?

.... 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How to do it in excel?

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,510
Default How to do it in excel?

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How to do it in excel?

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default How to do it in excel?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"