software

I need to insert the file name in a cell of the work page (with a funtion)
and be able to change automatically if amp; when the file name id edited. I Use
this on a cover page .

Deare De Silva,

Try the following array formula (Ctrl Shift Enter)

=MID(CELL(quot;filenamequot;),MATCH(quot;[quot;,MID(CELL(quot;filenamequot;),ROW(1:150),1),0) 1,MATCH(quot;. quot;,MID(CELL(quot;filenamequot;),ROW(1:150),1),0)-MATCH(quot;[quot;,MID(CELL(quot;filenamequot;),ROW(1:150),1),0)-1)

WHen you change the filename, i guess you would have to vlose and reopen the
file.

Regards,

Ashish Mathur

quot;Mohan De Silvaquot; wrote:

gt; I need to insert the file name in a cell of the work page (with a funtion)
gt; and be able to change automatically if amp; when the file name id edited. I Use
gt; this on a cover page .

Hello Ashish,

Tried entering the formula, but give result #VALUE!. What do you mean by
(Ctrl Shift Enter) is this to be done in the cell before entering the formula
??

Thanks amp; appreciate assistance
Mohan De Silvaquot;Ashish Mathurquot; wrote:

gt; Deare De Silva,
gt;
gt; Try the following array formula (Ctrl Shift Enter)
gt;
gt; =MID(CELL(quot;filenamequot;),MATCH(quot;[quot;,MID(CELL(quot;filenamequot;),ROW(1:150),1),0) 1,MATCH(quot;. quot;,MID(CELL(quot;filenamequot;),ROW(1:150),1),0)-MATCH(quot;[quot;,MID(CELL(quot;filenamequot;),ROW(1:150),1),0)-1)
gt;
gt; WHen you change the filename, i guess you would have to vlose and reopen the
gt; file.
gt;
gt; Regards,
gt;
gt; Ashish Mathur
gt;
gt; quot;Mohan De Silvaquot; wrote:
gt;
gt; gt; I need to insert the file name in a cell of the work page (with a funtion)
gt; gt; and be able to change automatically if amp; when the file name id edited. I Use
gt; gt; this on a cover page .

Check out this web page of John McGimpsey on the subject:

www.mcgimpsey.com/excel/formu..._function.html

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================quot;Mohan De Silvaquot; gt; wrote in message
...
gt; Hello Ashish,
gt;
gt; Tried entering the formula, but give result #VALUE!. What do you mean by
gt; (Ctrl Shift Enter) is this to be done in the cell before entering the
formula
gt; ??
gt;
gt; Thanks amp; appreciate assistance
gt; Mohan De Silva
gt;
gt;
gt; quot;Ashish Mathurquot; wrote:
gt;
gt; gt; Deare De Silva,
gt; gt;
gt; gt; Try the following array formula (Ctrl Shift Enter)
gt; gt;
gt; gt;
=MID(CELL(quot;filenamequot;),MATCH(quot;[quot;,MID(CELL(quot;filenamequot;),ROW(1:150),1),0) 1,MATC
H(quot;.quot;,MID(CELL(quot;filenamequot;),ROW(1:150),1),0)-MATCH(quot;[quot;,MID(CELL(quot;filenamequot;),R
OW(1:150),1),0)-1)
gt; gt;
gt; gt; WHen you change the filename, i guess you would have to vlose and reopen
the
gt; gt; file.
gt; gt;
gt; gt; Regards,
gt; gt;
gt; gt; Ashish Mathur
gt; gt;
gt; gt; quot;Mohan De Silvaquot; wrote:
gt; gt;
gt; gt; gt; I need to insert the file name in a cell of the work page (with a
funtion)
gt; gt; gt; and be able to change automatically if amp; when the file name id
edited. I Use
gt; gt; gt; this on a cover page .=CELL(quot;filenamequot;,A1)

File must be saved before it will work......

Vaya con Dios,
Chuck, CABGx3quot;Mohan De Silvaquot; gt; wrote in message
...
gt; I need to insert the file name in a cell of the work page (with a funtion)
gt; and be able to change automatically if amp; when the file name id edited. I
Use
gt; this on a cover page .
Mohan

Check out Bob Phillips' site for this.

www.xldynamic.com/source/xld.xlFAQ0002.htmlGord Dibben Excel MVP

On Thu, 22 Dec 2005 15:52:02 -0800, quot;Mohan De Silvaquot;
gt; wrote:

gt;I need to insert the file name in a cell of the work page (with a funtion)
gt;and be able to change automatically if amp; when the file name id edited. I Use
gt;this on a cover page .