This thread needs to be moved to the VBA forum.
Quote:
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.