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