Steve,

Yes it is possible but it isn't completely trivial and there isn't a one-size fits all solution. There are multiple places where metadata can be saved (custom xml, built-in and custom document properties, document variables) and because of this, there are multiple ways to connect content in the document to those document variables.

Are you looking for a big-bang approach macro to CREATE all 200 documents at once or do the documents already exist and you want to have them REFRESH their variables from the Excel source? Option 1 is more straightforward since you will have consistent structure to work from. If the documents already exist then there is a lot of extra validation that must take place to ensure the 200 docs contain what the macro expects.

From your post, it appears you already have the 200 docs and want to refresh the metadata. Charles' links are directly applicable to that 'process' but you will need to use the vba framework available in those links to process the Excel data and update it in each of the relevant docs. If you need assistance to get going on this, you will need to post a sample Excel workbook and a representative Word document so that we can see where the metadata is being saved in the Word docs. If the field titles don't match in both the source spreadsheet and Word docs then we would need a mapping table as well.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia