Updating Custom Word Document Properties

Italophile · #2 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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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