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

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.


In article ,
Justyna wrote:

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

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


Justyna wrote:

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

--

Dave Peterson

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

"JE McGimpsey" wrote:

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.


In article ,
Justyna wrote:

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

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

"Dave Peterson" wrote:

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


Justyna wrote:

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

--

Dave Peterson

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

On Tue, 4 Sep 2007 08:38:02 -0700, Justyna
wrote:

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

"Dave Peterson" wrote:

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


Justyna wrote:

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

--

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.

Justyna wrote:

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

"Dave Peterson" wrote:

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


Justyna wrote:

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

--

Dave Peterson


--

Dave Peterson