Updating Custom Word Document Properties

[Hafiz Choudhury]

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

[Italophile]

This thread needs to be moved to the VBA forum.

Originally Posted by Hafiz Choudhury

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

Yes, but it will still require the Word application to run and each document in turn to be opened, updated, saved and closed.

The code to do this is largely the same as it would be if you did it from Word.

Just realised you're using macOS.
Find a Windows machine to use if you need to run this from Excel. The ability to automate another Office application using VBA is fundamentally broken on macOS.

[Hafiz Choudhury]

Thanks. I can use Parallels to run the job in a Windows instance but unsure of the commands I need to use in VBA to update the custom document properties.

[Charles Kenyon]

Originally Posted by Italophile

This thread needs to be moved to the VBA forum.

Moved to vba forum.

[Italophile]

You can start from Document.CustomDocumentProperties property (Word) | Microsoft Learn