I am creating a set of Word document that take client documents, cleans them up and then makes them editing for further editing.



One aspect of this is a set of 'House styles'. Currently these styles are defined programatically and consequently only the final result is visible to users.

What I would like to do is to store the relevant style details as deltas from the 'Normal' style in a workbook so that each style set has its own spreadsheet.

The advantage of this is that it makes it relatively easy for users to create style sets that a specific to individual clients.

However this means my macro has to rely on reading data from an external spreadsheet. I have no problems in doing this but am aware that it would be relatively easy for the spreadsheet with style information to become lost or badly managed to become less useful or unworkable.

Therefore what I would like to do is to store the spreadsheet inside the word zip file and to have a macro that exports and reloads as necessary.

Can anyone point me to articles that discuss how to insert and extract arbitrary files within the word zip folder.

I am currently following up on Custom XML parts but am finding it a bit hard work and I'm not entirely sure that this would do what I want without additional programming to create the custom xml rather than just storing a Excel workbook.

Thanks in advance.