Tocogroup
asked on
How do I populate a Word 2010 HTMLText box from Excel ?
Hi,
I've been sent a Word document with a number of input form fields. However, they don't appear to be legacy or ActiveX label or text box controls as when I check their properties they have far few attributes, for example...
Name DefaultOcxName9 (HTML TextArea)
Columns 39
Height 102.75
HTMLName ctl00$ContentMain$RoomCont actForm$Tb Address
Rows 8
Value
Width 170.25
WordWrap OFF
What sort of controls are these ? And how do I refer to them in Excel VBA if I want to populate them from a worksheet.
Thanks
Toco
I've been sent a Word document with a number of input form fields. However, they don't appear to be legacy or ActiveX label or text box controls as when I check their properties they have far few attributes, for example...
Name DefaultOcxName9 (HTML TextArea)
Columns 39
Height 102.75
HTMLName ctl00$ContentMain$RoomCont
Rows 8
Value
Width 170.25
WordWrap OFF
What sort of controls are these ? And how do I refer to them in Excel VBA if I want to populate them from a worksheet.
Thanks
Toco
Can you post the document (or a relevant bit of it), so we can see exactly what it is, please?
ASKER
As attached
Room-Booking-Form-Original.docx
Room-Booking-Form-Original.docx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your combined efforts - code and explanation.
It works fine. Much appreciated.
It works fine. Much appreciated.