Update label in word document with value in excel cell

[Pegaso]

Hello All,
I have been looking for the answer an I couldn't find anything that works, apologies in advance if this issue has been solved here before!
I need excel to open an existing word document (checked!) and update a Label on it with the value in a cell (not checked!). It sound really easy, but I didn't succeed!
I create a word document, go developer / Design Mode / Legacy forms / Text Box (ActiveX control). The Text box will contain the value from the excel cell. Text Box is called TextBox1 and the property I need to pass the excel value from is called "Value"
How can I link excel to the value in the TextBox?
I have the following code:

but it fails in the line:
objword.TextBox1.Value = Sheets("Sheet1").Cells(1, 1)
Run-time error 438: Object doesn’t support this property or method
I know it should be something really silly, but I can’t find out, thanks in advance for the help!

[walruseggman]

Your syntax is a bit off. You need to set objDoc equal to the file you open, because that's where the TextBox is, not in ObjWord, which you've only set to the Word Application.

Please Login or Register  to view this content.

[Tinbendr]

Please Login or Register  to view this content.