Filename Function?

D.Rodriguez · Sep 15, 2004

Is there a function that will display the filename in (1)
a cell, and/or (2) a header/footer? I'm using Excel 97.
Thanks.

JE McGimpsey · Sep 15, 2004

Gord Dibben · Sep 15, 2004

Filename only can be inserted in default footer/header setup.

If you want full path and filename in header/footer you will need a VBA macro.

http://www.mcgimpsey.com/macoffice/excel/fullnameinfooter.html

Gord Dibben Excel MVP