Hi Folks,

I am using an Excel macro to populate a Word 2010 document with data. I'm struggling with some aspects and have hit a brick wall. The Word document is opened from a template .dotx which has a bunch of table cells for the user to enter data. Users can use the template in two ways:

1. They can manually create a new blank document to edit via File - New - My Templates
2. Or they can run a macro from within Excel to create and populate a new file automatically

If the user choses option 1, to speed up the data entry some of the cells have drop-down list content controls which contain lists of names to pick from.

The word template has a bunch of bookmarks which the excel macro uses to paste data into. Most of the bookmarks apply to empty table cells and the macro populates these with data perfectly. So far so good.

However, a couple of bookmarks are applied to a couple of drop-down lists and this is the problem: they won't pick up the values pasted to their bookmarks by the macro. I can't get my head around this. Bookmarked date picker content controls are picking up the values from the macro, but bookmarked drop-down list content controls do not pick up the values from the macro.

Am I attempting the impossible?

Enormous thanks for any help!