VBA to Populate text content controls in word from excel

		Microsoft Office Forums > Microsoft Word > Word VBA
VBA to Populate text content controls in word from excel

FAQ

Thread Tools

Display Modes

#13

11-23-2021, 04:44 AM

gmayor

Windows 10 VBA to Populate text content controls in word from excel

Office 2019

Expert

Join Date: Aug 2014

Posts: 4,144

If the document is being used as a template then instead of opening the file create a new file from it i.e.

Code:

Set oDoc = objWord.Documents.Add("https://XXXX-my.sharepoint.com/personal/" & UserName & "_XXXX/Documents/_MyProfile/Desktop/Business%20Executive%20Summary%20MASTER.docx?web=1")

That document is then unnamed, so you can add a line to save it wherever you want with whatever name you want.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Content Controls for large quantities of text	tonia8675309	Word	5	06-08-2018 04:42 PM
Populate Content Control Dropdowns from Excel	Deirdre Kelly	Word VBA	23	09-07-2017 02:51 PM
Rich text/Plain text Content Controls in Template	michael.fisher5	Word	9	11-19-2014 06:36 AM
Moving between Rich text content controls	Sammie0Sue	Word	4	03-12-2014 01:43 AM
Rich Text Content Controls: Formatting?	tinfanide	Word VBA	8	03-04-2013 04:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:02 AM.