You can download and use this free add-in:

http://j-walk.com/ss/excel/files/addpath.htm

MRO


"Don Wiss" wrote in message
...
I'm using Excel 97. I know I can put =CELL("filename") in a cell, and then
have a macro assign that to the footer, but is there an & keyword that
will
return the full path without this kludge? Knowing that &[File] returns the
file name, I tried words like Filename, Path, and Pathname, but to no
avail.

Don <donwiss at panix.com.