Updating Custom Word Document Properties

Italophile · #1 08-27-2024, 05:07 AM

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.

Hafiz Choudhury · #2 08-27-2024, 09:46 AM

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 · #3 08-27-2024, 04:45 PM

Quote:

Originally Posted by Italophile

This thread needs to be moved to the VBA forum.

Moved to vba forum.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with Excel macro to extract all custom properties of Word Document to later mass update	anmalogo	Excel Programming	2	04-29-2024 12:36 AM
sort custom document properties	LQuinn	Word VBA	4	03-17-2021 05:19 PM
Adding Custom Document Properties	NicoleJones	Word VBA	3	03-10-2021 08:43 PM
Create Custom Document Properties with Content Control	kschmidt	Word VBA	7	02-04-2019 03:09 PM
Updating Document Properties without using advanced properties dialogue	thedr9wningman	Word VBA	3	01-20-2014 05:56 PM