Well I would hope that you are doing it as a real template, rather than a document open. After all, if the document is opened again, then the code will run again...thus changing the date. Surely this is not what you want.
If it was a template, using Document_New (not open), then the date would go in once (and only once).
That aside, you probably do not need to "activate" the cell - there is no activate BTW.
Perhaps use a bookmark. In which case the current date could be inserted at the bookmark. You could do this directly, with no need to "activate". This could also add 30 days to another bookmark value.
BTW: is the text "Date Raised:" already in the cell?
|