I should be more specific...I am using Excel 2000. I see where code can be
used. Is there some code I can use that will work automatically in any
workbook? Or would it be easier to use macro, and how would you implement
that macro
--
Gator


"ShaneDevenshire" wrote:

Hi,

When you say &[Path] doesn't work, do you mean it doesn't put in the path or
do you mean it puts in more than you need?

1. If #1 then you probably need to save the file first
2. If #2 then you need to write VBA code and add it to the Before Print
event of the thisWorkbook object.


--
Thanks,
Shane Devenshire


"Gator" wrote:

What do I use to add the directory as a custom footer in the View/Header
Footer...I've used &[Path] and that doesn't work. I see a button to add the
file name...that's easy...but I can't get the directory on there.
--
Gator