(Solved) – VBA Using Excel 2016 to Populate Word 2016 Content Controls

  • by

I’m attempting to populate a Word.dotm document that has content control text boxes using Excel.

In Excel, I create the word objects and open the file, but I can’t figure out how to actually access the controls.

In the Word doc’s VBA, I can access them via

.SelectContentControlsByTitle("control").Item(1).Range.Text = "..."

but that doesn’t work using an Object in Excel.

Leave a Reply

Your email address will not be published. Required fields are marked *