John Walkenbach has an addin you may like.
http://j-walk.com/ss/excel/files/addpath.htm

It builds the macro code for you.

Jeanne wrote:

How do it automatically set the entire folder path and file name in a footer?
(ver 2000)

--

Dave Peterson