Macro Code to Update Custom Properties

First off, this may be the wrong subforum as this is an interface between excel and word. But I trust this forum for any and all help with excel macro issues, so thank you to you all for the awesome help.

My issue is with custom properties in a word report template, which we use to autofill information. Useful, helpful - just incredibly annoying because of the very limited and half functional interface on Word.

I recall at some point hearing about how you can build an excel document to type in all of whatever custom properties you are wanting - then just run a macro code and it will carry those cells over to update the custom property values. I just am not having much luck in typing in the correct order of search terms to find exactly what I am looking for and instead shifting through hundreds of articles that just touch the basics of custom properties.


Any help, including pointing me in a better direction if this is not actually the correct (although I believe closest) subforum for this type of issue.

Thanks

Yes, that is the custom document properties for word.