View Single Post
 
Old 07-31-2019, 04:09 AM
lmoir87 lmoir87 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jul 2014
Posts: 7
lmoir87 is on a distinguished road
Default VBA to Populate text content controls in word from excel

Hi

I am trying to populate a word document with named ranges/cells in an excel template.

My first iteration was using 'Label' and i was able to get these to populate as follows;

Code:
ThisDocument.Label1.Caption=workbook.Sheets("Sheet1").Range("Label1)
However, I would prefer to use a Rich Text content control, so that the formatting matches the document and so it is possible to click into the content control after it has been populated.

Thanks
LM
Reply With Quote