DblDocWhitaker
New Member
- Joined
- Mar 31, 2020
- Messages
- 10
- Office Version
- 2016
- Platform
- Windows
I am not a programmer, but am trying to build a user interface in Excel that will facilitate my colleagues in auto completing letters and forms. Right now I have the interface moving the user thru a series of questions to identify the form too be used and the info to be inserted (info put into text box or drop down menu saved as strings). I also have it set to open the appropriate document/template. However, I cannot figure out how to to find text in the word document and replace it with the string entered into the text box. I can get the doc to open.
For example, I have:
Dim NameFull As String
NameFull = Me.txNameFull.Value
'open word doc code here
In the Document I have <<Full name>> that I want to replace with the string saved as NameFull. I tried controlcontent and had no luck - figured find/replace might be easier. So far not really.
Thanks!!
For example, I have:
Dim NameFull As String
NameFull = Me.txNameFull.Value
'open word doc code here
In the Document I have <<Full name>> that I want to replace with the string saved as NameFull. I tried controlcontent and had no luck - figured find/replace might be easier. So far not really.
Thanks!!