Hi, not sure if this is the right forum maybe should be in the excel forum, but any help will be appreciated....

I have a Word 2010 document with a number of rich text content controls. I want to populate certain cells with specific content controls of the excel file as it opens (the word document will also be open).

i.e.

Word content control CC1 data to excel cell C5
Word content control CC2 data to excel cell C6
Word content control CC5 data to excel cell E1

I can only seem to find code that copies all content control data to an excel row. Also the filename of the word document wont always be the same or in the same location...................