EDIT: is this like subdocuments? That is, Microsoft's position is this. "Yes, it's there for historical reasons but it's so embarrassingly broken and useless we only expect you to use it if you're an idiot."

Code releases are done here via inserting the objects in a Word document with instructions and providing the document to the user.

The user then does one of two things; either saves the objects to disk or opens the file into its associated application.

They then follow the instructions.

(Nothing to do with me, just telling you how it is.)

The objects could theoretically be files of any type, but are usually SSIS packages or SQL scripts, thus .dtsx and .sql extensions.

With a great many objects, refreshing them becomes cumbersome, fiddly and tedious.

I'd like to use VBA to auto-refresh every object in a document. That is, overwrite the object in in the document with a fresh one from disk.

The objects are right there in the document, I can read and write their properties, and insert and delete them.

However, changing any of the properties using VBA breaks something, usually the file association so it no longer opens on double click, or sets the name to a random 8.3 name.

The "Properties" and "Rename Object" menu items are no better.

Can anyone that has experience of this confirm that there is a way to make this work?

Are there other objects I should be using?

Can you point at a resource i could use to learn about this?