Is there a method of updating word 2011 (Mac) custom document properties without using the word application directly. I use an iMAc on High Sierra.



I have 20 custom properties which will change for every document.

I can change the values manually for each document version using FILE>PROPERTIES>CUSTOM>select the custom variable>alter the value>MODIFY.

But I want to automate this process when I need to do more that one document.

I want to list all the property values in a spreadsheet for each instance and then press a VBA button to print a new document version with the new values.

In the word document I use DOCPROPERTY to print the value of the custom property, e.g. {DOCPROPERTY "GeminiInvNum"}. (with the correct word generated curly brackets.

e.g. Is it possible to make an API call from Excel to update the custom properties.

The 20 different custom properties are a mixture of text, boolean, number and dates.

Thanks