printing full path name in footer?

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.