ptolemy

I am trying to create a default template that displays the file path. I have tried opening Normal.dotm, adding the file path footer that I have created, and then saving the file. My problem is that when I create a new document, it has the path to Normal.dotm. So it seems like the result of the macro is being saved, rather than the macro itself. Does anyone have any thoughts, because I'm at my wits end?