full file path information in header or footer

[mango]

hi all,
may i know how to make the full file path for example, \\server
drive\project\status\file1.xls to appear on header or footer?

pls help.
thanks

 

[Govind]

Hi Mango,

You can use this formula to show the file path

=CELL("filename",A1)

Not sure how to show this in header. As a alternative, you can go to
File -> Page setup and choose Sheet tab and select the first row as the
"Rows to repeat at top".

Regards

Govind

 

[Ashish Mathur]

Hi,

Try the cell("filename") function. Filename is the name of the file which
you have saved.

Regards,

Ashish

 

[Frank Kabel]

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

 

[Gord Dibben]

mango

If using Excel 2002 or 2003 this feature is available in Custom header or
footer.

Just click on the folder icon.

If earlier version, use code.

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

Adjust to suit.

Gord Dibben Excel MVP