Push Data from Excel to MS Word Content Controls using Excel VBA 

I found this video helpful and detail oriented. It seems so much more simple when you explain things in detail. Seeing a code provides more information regarding how a process is completed. Thank you.

This video will definitely come in handy when I need to refresh my memory about how to transfer data from Excel to Word. After watching this, I learned some great tips as well as gained a better understanding, which will help me to succeed in the future.

i found this video very helpful in that I will eventually most likely need to implement data from excel into a word document. Doing research and writing about it would require me to attach any data that i collect and wish to display. This video was an in depth demonstration on how to achieve this.

Having been out of school for decades and not being technologically inclined it amazes me how much we can do with computers and programs now. Watching the video did jog my memory, but I will be returning to follow step by step in the future. Thank you for a clear and concise tutorial.

This was a great introduction to push data using excel for me. I am a visual learner, and being able to see what was being explained was very useful to my learning.

Exactly what I needed and saved the day! I didn't realize it was so simple.

I couldn't use Mail Merge for my project because there is relational data for each contract (Word document). This, SIR, is amazing. Thank you.

Great video. Using the step-by-step guide was very helpful.

This video gave a lot of information. I'm not to familiar with Excel but I was able to add the developer to the home tab. I'm going to have to go over this video a few times

Great video! Just what I wanted to know. Thank you!

Wow! This video was very informative and helpful. The presentation was easy to understand and I am excited to try to use this on my own.

This is excellent Todd! I appreciate the video demonstration of this; it was tremendously helpful for solving a problem with automating some really boring stuff! ;D

I'm definitely grateful for this video because this would be very confusing without the step by step walk through. It's good information to know, though, because it will help to make the information and data entered into excel passed easier into word where a research paper might be written. I'm also glad I took a computer science class in college because it made it a little easier to understand what was happening.

Thanks ! This video is much helpful.

This video is very informative and helpful.

I appreciated the step-by-step guide of navigating through this transition of data to and from Microsoft Word. I am still too confused to attempt this on my own. However, I have saved this video so that I can come back to it and study the steps.

This video will be helpful to reference when I need to push data from Excel to Word. I also found it interesting how an adjustment to the code will allow info to be pulled from Word. I look forward to using this macro. Thank you.

Very relaxing.

Good and informative video.

Thank you so much, That was helpfull

Wonderful video!!!!!

Thank you - this is great! I have used this successfully to pull info to a word form. The only problem is that Word is not closing completely. I have to open the document twice after I update it to see the new information appear in the document. Any chance there is a line of code that can do a better job of closing it all up?

Hi there, thank you for this great effort. I have a problem with Excel , wvry time I create a micro enabled Excel sheet it ends up cracking and shows the message"Excel has stopped working". Even though the code is not that complicated. Just simple navigation code with a couple of equations. Hope you have an answer. Thanks again.

Very informative video. I didn't even know this was possible. I do have a question, however. Why not just copy and paste the information into a Word document or "Open with...Microsoft Word"?

Thank you so much

Thank you for the video... (Very helpful however posting the code would be great. ) QUESTION: How would you do it via LATE Binding? Early Binding can have many problems if the code will be used by users that may not have the Word Ref / Obj library set.

Hi, thank you for a great tutorial, wish i had known this two years ago. But i get an error replicating it: Run error 13 Type mismatch

Good morning sir, thank you for the demonstration that help me a lot to to copy data from access to word that work correctly, however when I inserted the rich text ms word content controls in header section of word document the code doesn't work (the content control remained empty). Is there a solution for this case?

Thank you. Sir, could you please show making this process with multiple data, i mean multiple pages..

Can you push date from an entire row instead of a column? I'm trying to populate word documents with names, address, etc from an excel spreadsheet ? Thank you!

Great but it it possible to have the code in the notes ? ( easier to copy and avoid mistakes )

شكرا

I get it. I just wish the codes to push the data was easier to write. But, I get it.

hi, Dr.grande I want to develop an action plan title plagiarism checker. the previous title stored on excel and when I paste on search box it must show me percent of edite and copy. Also, it must show me the best Action plan achievement or 100℅ free of plagiarism

What is the benefit of using rich text content control vs plain text?

Thank you very much for the information, can you help me further at all? I get an error 'compile error: user-defined type not defined' It then highlights the first line 'Dim word app As Word.Apllication'

Hey...Even though Liabarary is checked getting user defined error.. could you please advice how to go.

Nice one can you do for excel to word

I'm getting a subscript out of range error when I try to replicate this, any ideas what I may have missed?

Hi.Great video, thanks.I am getting an error - as follows.All the variables get Set except wDoc, it = NothingI have the following;Dim wordApp As Word.Application Dim wDoc As Word.Document Dim r As Integer Set wordApp = CreateObject("word.application") Set wDoc = wordApp.Documents.Open(ThisWorkbook.Path & "/" & Range("G3").Value & ".docx") wordApp.Visible = TruewordAPP = "Microsoft Word"ThisWorkBook.Path sets as expectedRange("G3").Value & ".docx") brings back the required document name.docxI also had to addDim i As Integerto get the Fo - Next I to work as well?Any ideas as to what may be wrong?Thanks in advance.Brad