I have been assigned the task of creating a macro that will put the time and date in the footer automatically on every document that is created in MS Office (Word, Excel, PowerPoint). Does anybody know how to do this and what would the best way to do this for several networked machines. Thanks in advance Bill

Ok, I think I figured this out for myself, instead of creating a macro I did this for Word. How I did it in Word 97 was, first create a file with the Date and Time in the footer an then I saved the file as a .dot (template) file, Then I moved it to the MS Office Template folder, on mine it was c:\program files\microsoft office\templates. Second I completely closed down word and then deleted the file named normal.dot in the template folder. Finally I renamed my .dot file that I moved; to normal.dot. Now everytime I open up word this will be my default file. I'm gonna try this with excel and PowerPoint next.

So, just out of interest, tell us which date you are using? Createdate, so it only shows the document's original birth? The Savedate so it always shows the date the document was last updated?

I'm using the Savedate so it always shows the date the document was last updated. The department where I work is having problems with to many files being saved for the same project. They wanted an easy way to see which was truly the last edited doc. e.g. Instead of Expansion1FinalFinalFinal.doc

Yep, that makes sense. :)