Paste file name into cell

[JulieK]

I am trying to have Excel automatically paste the file name into a cell - I
don't want to use the header or footer for this. Thanks, Julie

[Vito]

Try:

=CELL("filename")

[Gord Dibben]

Julie

See Bob Phillips' site for this.

http://www.xldynamic.com/source/xld.xlFAQ0002.html


Gord Dibben Excel MVP

On Wed, 14 Dec 2005 13:47:47 -0800, JulieK <[email protected]>
wrote:

>I am trying to have Excel automatically paste the file name into a cell - I
>don't want to use the header or footer for this. Thanks, Julie