software

Hi

I wan't to get the name of the Excel - sheet in a cell, for
example:

If i call the sheet quot;2006quot; i want just 2006 to be in cell A1.

Are there anyone who now how i shall do???

Regards.

Gunnar K

=MID(CELL(quot;filenamequot;,$A$1),FIND(quot;]quot;,CELL(quot;filenamequot;,$A$1)) 1,100)quot;Gunnar From Swedenquot; wrote:

gt; Hi
gt;
gt; I wan't to get the name of the Excel - sheet in a cell, for
gt; example:
gt;
gt; If i call the sheet quot;2006quot; i want just 2006 to be in cell A1.
gt;
gt; Are there anyone who now how i shall do???
gt;
gt; Regards.
gt;
gt; Gunnar K

This only works on previously saved workbooks.......=MID(CELL(quot;filenamequot;),FIND(quot;]quot;,CELL(quot;filenamequot;),1) 1,99)

Vaya con Dios,
Chuck, CABGx3

quot;Gunnar From Swedenquot; wrote:

gt; Hi
gt;
gt; I wan't to get the name of the Excel - sheet in a cell, for
gt; example:
gt;
gt; If i call the sheet quot;2006quot; i want just 2006 to be in cell A1.
gt;
gt; Are there anyone who now how i shall do???
gt;
gt; Regards.
gt;
gt; Gunnar K


--
Keep the Hopequot;Gunnar From Swedenquot; wrote:

gt; Hi
gt;
gt; I wan't to get the name of the Excel - sheet in a cell, for
gt; example:
gt;
gt; If i call the sheet quot;2006quot; i want just 2006 to be in cell A1.
gt;
gt; Are there anyone who now how i shall do???
gt;
gt; Regards.
gt;
gt; Gunnar K