View Single Post
 
Old 01-19-2013, 09:53 PM
fumei fumei is offline Windows 7 64bit Office XP
Expert
 
Join Date: Jan 2013
Posts: 440
fumei is on a distinguished road
Default

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?
Reply With Quote