full file path in header?

[sallyt]

Hello, Please tell me it's possible to automatically put
the full file name and path into a header or footer in
Excel? I know it can go into a CELL, but want it to print
on the header or footer. How on earth ?? Thanks a lot!
Sally

 

[David McRitchie]

Hi Sally,
Unless you have Excel 2002 you will need a macro. See the
following for solutions regardless of your version.

Pathname in headings, footers, and cells
http://www.mvps.org/dmcritchie/excel/pathname.htm