full file path information in header or footer

M

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
 
G

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
 
A

Ashish Mathur

Hi,

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

Regards,

Ashish
 
G

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
 
Top