Insert File Source Path in Workbook

[Carl]

In excel 2000 are you able to insert the files path on at
the base of the workbook as say a footer? Not just the
filename - the whole path eg:
h:\mydocuments\excel\book1.xls

 

[David McRitchie]

Hi Carl,
Not part of Excel 2000, though it was added in Excel 2002.

For versions prior to Excel 2002 you need a macro.

An example of a macro for Excel 2000 can be seen in
http://www.mvps.org/dmcritchie/excel/pathname.htm
look for "Workbook_BeforePrint" within a box.

===
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

 

[Dave Peterson]

You could write a macro that would do this for you. Or you could download John
Walkenbach's addin:
http://j-walk.com/ss/excel/files/addpath.htm

John's addin actually writes the macro for you.

(xl2002 is the first to support this directly.)