Insert the filename and path where?

In a header or footer?

I don't use 2007 but 2002 and 2003 versions had a path and filename icon in
Custom Footers and Headers under print setup.

I can't believe Excel 2007 wouldn't have the same feature.

Macro if you want one.

Sub PathInFooter()
ActiveSheet.PageSetup.RightFooter = ActiveWorkbook.FullName & " " & _
ActiveSheet.Name & " " & Application.UserName & " " & Date
End Sub


Gord Dibben MS Excel MVP


On Tue, 15 Jan 2008 15:46:02 -0800, Christine
wrote:

We are trying to figure out how to insert the file name and path in Excel
2007. We are also looking for the same in Word 2007. Is it possible to
create a macro or shortcut for this that we can place in the quick access bar?