Repost of printing full path in footer.

Note: I am reposting this question so that I can properly award the points to the person who answered the question for me the first time. (I messed up and he didn’t get the points. I want him to get them)

I should know this but the solution is escaping me so someone please help. I need to print the full path and file name in the footer of my Excel spreadsheet (97 or 2000). Where do I set that up or do I have to create a macro or VBA procedure to do it? I am an advanced user so please don’t give the basic how to’s in your answer. Thanks in advance.