This is a similar problem I've had before but in a different scenario.
I have an Excel 2010 macro which, on a click of a button:
1. Opens a Word 2010 document
2. Takes values from the Excel sheet and populates ActiveX label control placeholders in the Word document.
I'm getting an 'Error 438 Object doesn't support this method or property' when it tries to populate the first label on the Word document.
I have selected the 'Microsoft Excel 14.0 Object Library' entry in Tools --> References and have attached the Excel workbook (TD9.xlsm) and the Word document (ET9.docx).
My questions are:
Why do I get an Error 438 on a Word label control ?
Does it matter if the Word document is either a .docx or a .docm (given it only contains controls and no actual code) ?
Thanks for your help