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

Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox	0	Sep 1, 2021
Put filename in a cell	2	Aug 9, 2006
This function returns incorrect value sporadically	1	Jul 31, 2008
filename function	2	Feb 25, 2004
Vlookup and return sheet name also	2	Nov 20, 2012
What is the Excel equivalent of the CELL function?	8	Sep 4, 2006
Pulling Tab Name of a Different Tab Than What I'm Working In	7	Feb 1, 2010
using the Cell function	2	Jul 20, 2009

Ask a Question