Use VBA to set word custom doc property to current date

[stercorum]

I want to use VBA to change a CustomDocumentProperty Value to the current
date (month and year only).

My reason is in order to automate hidden publication dates stored in the
document at the point of compiling a PDF. I will run the VBA from a toolbar
button just prior to compiling the PDF.

Does anybody know how I can do this?

 

[macropod]

Hi stercorum,

Assuming you've defined the custom property "DocDate", you could set its
value with:
ActiveDocument.CustomDocumentProperties("DocDate") = Format(Date, "MM-YYYY")

You can then access the property in your document via a DocProperty field.
The above would return 06-2006.

As an aside, if all you're after is the current date formatted as month and
year, you could use any one of a DATE, CREATEDATE, SAVEDATE or PRINTDATE
field, according to your requirements and format it to display only the
month and year, with no need to use vba or Custom Document Properties. For
example:
{DATE \@ "MM-YYYY"}
would also return 06-2006

Cheers

 

[stercorum]

Excellent, thanks. I knew the answer had to be simple, but without your
assistance I might never have discovered it.

Hi stercorum,

Assuming you've defined the custom property "DocDate", you could set its
value with:
ActiveDocument.CustomDocumentProperties("DocDate") = Format(Date, "MM-YYYY")

You can then access the property in your document via a DocProperty field.
The above would return 06-2006.

As an aside, if all you're after is the current date formatted as month and
year, you could use any one of a DATE, CREATEDATE, SAVEDATE or PRINTDATE
field, according to your requirements and format it to display only the
month and year, with no need to use vba or Custom Document Properties. For
example:
{DATE \@ "MM-YYYY"}
would also return 06-2006

Cheers
--
macropod
[MVP - Microsoft Word]

I want to use VBA to change a CustomDocumentProperty Value to the current
date (month and year only).

My reason is in order to automate hidden publication dates stored in the
document at the point of compiling a PDF. I will run the VBA from a toolbar
button just prior to compiling the PDF.

Does anybody know how I can do this?