ActiveWorkbook.ContentTypeProperties("DateOfAction").Value = Month(Date) & "/" & Day(Date) & "/" & Year(Date)
Does not work, however it does work if DateOfAction is a text field. The problem is, DateOfAction is a date field, and requires you to click a picture of a calendar and click a date to make an entry into it.

All I want to do is force it to put todays date in the DateOfAction field.


Any ideas?