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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top