Show where worksheet is saved in the header/footer

[Guest]

I would like to show the path of where the workbook is saved in my computer
in either the header or footer, so that on every page that is printed,
someone else can see the c:/...path and use that to find the documents
location. As well, if I move the excel doc, the path will be updated in the
workbook automatically.

Thank you for all your help in advance

Justyna

 

[JE McGimpsey]

One way:

Choose File/Page Setup, and choose Customize Header (Footer) in the
Header/Footer pane. Select the Left, Center, or RIght Header (Footer).

Click the Insert File Path button.

 

[Dave Peterson]

This was added as a built-in feature in xl2002.
File|page setup|header/footer tab|Custom footer (or header)
Click on the icon for the path (and the filename??)
(xl2003 menu system)

If you're not using xl2002+, you may want to try John Walkenbach's AddPath
addin:
http://j-walk.com/ss/excel/files/addpath.htm

 

[Guest]

I have Excel 2000. The method that you wrote only places the file name and
the file tabs name, not the actual path, eg C:\Documents and
Settings\nrollings\Desktop\Inventory. do u know how I can get this to be
displayed on the print outs

 

[Guest]

I hav Excel 2000, is the link safe to download from or does excel 2000 have
this function build in as well?

 

[Gord Dibben]

Excel 2002 was first version to have the fullpath feature, as Dave noted.

John's Addpath is safe to download and install.

You could also use a macro.

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


Gord Dibben MS Excel MVP

 

[Dave Peterson]

It's safe (but why would you believe me if you don't trust the link???)

And that feature was added in xl2002.