I think your research into what NORMAL.DOT is and does should give you 98% or maybe 100% of what you want to achieve.
I want to create an icon in normal.dot which when clicked auto enters the path and file name in the footer. Steps would be:
1. create a document
2. save the document somewhere
3. click the icon and have the macro insert the path and filename.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic