Change text in a Word content control with VBA in Excel

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Change text in a Word content control with VBA in Excel

FAQ

Thread Tools

Display Modes

02-08-2024, 09:08 AM

Italophile Italophile is offline

Windows 11 Change text in a Word content control with VBA in Excel

Office 2021

Expert

Join Date: Mar 2022

Posts: 554

Try:

Code:

Sub ReplaceText()
    Dim wApp As Word.Application
    Dim wdoc As Word.Document

    Set wApp = CreateObject("Word.Application")

    wApp.Visible = True

    Set wdoc = wApp.Documents.Open(ActiveWorkbook.Path & "\teste.docx")

    wdoc.SelectContentControlsByTitle("my_name_control").Item(1).Range.Text = "new text"

End Sub

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change Value of a Content Control based on the value of another content Control	jsc_msoffice	Word VBA	2	05-21-2021 09:51 PM
Copy Formatted Text in one Rich Text Content Control to another Rich Text Content Control	Haygordon	Word	1	04-05-2019 05:43 AM
Change text colour for content control labels?	Toe	Word	1	01-17-2019 08:45 AM
Is there a way to anchor drop-down content control boxes so entering text doesn't change formatting?	TzarChasm	Word	7	04-14-2016 06:28 PM
How to retrieve text from a word content control in VBA	jeffaus	Word VBA	1	03-14-2013 11:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:40 PM.