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.
@angelinastanton79966 жыл бұрын
I am also not very good with technology, and I struggle with Excel. I also tend to easily type in the wrong numbers or codes, which ruins all of my data. However, this is very helpful if you can practice using Excel regularly. I also saved this video so that I can watch it again and study it.
@virginiamurrey91396 жыл бұрын
This was a great example, to be able to see visuals during the explanation was extremely helpful.
@veronicabetz94526 жыл бұрын
I agree that technology has come along way. This program simplifies everything and saves so much time and aggravation. I will also have to follow the step by step instructions, but after a few tries I should be able to remember it.
@dHunter945 жыл бұрын
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.
@tyonnabrooks7486 жыл бұрын
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.
@wholelottageek88055 жыл бұрын
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.
@RyanPclifton5 жыл бұрын
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.
@virginiamurrey91396 жыл бұрын
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.
@aviatrix24 жыл бұрын
Exactly what I needed and saved the day! I didn't realize it was so simple.
@angelinastanton79966 жыл бұрын
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.
@suzgen73236 жыл бұрын
Angelina - I had excel/word open and attempted to go along with the video. It was helpful to be hands on for me to get a better idea of the processes. I'm not sure though if we will need to use this for our project but at least have an idea. I can understand how it would be helpful especially if survey data is changing frequently to ensure that your main document is continuously current.
@rebeccafalter22066 жыл бұрын
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.
@wardellwhittaker8596 жыл бұрын
I also took a computer science course in C++ many years ago. I just wonder why the codes are not easier to write now-a-days.
@johnharrisjr28086 жыл бұрын
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
@kaitlynforaker98326 жыл бұрын
Great video. Using the step-by-step guide was very helpful.
@suzgen73236 жыл бұрын
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.
@tyonnabrooks7486 жыл бұрын
It is quite interesting how one change can make a huge difference.
@rebeccafalter22066 жыл бұрын
It's seems as though you have a good understanding of this type of code and application. I think it's important to know to make it easier to transfer data into a new setting, and I feel better knowing that someone in my class might be able to help me do this with Dr. Grande is unavailable. (also with help from this video)
@robbieknott69015 жыл бұрын
Great video! Just what I wanted to know. Thank you!
@veronicabetz94526 жыл бұрын
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.
@MohAboAbdo2 жыл бұрын
Thank you so much
@rhondabaileyyy6 жыл бұрын
This video is very informative and helpful.
@abhijeetghosh31575 жыл бұрын
Thanks ! This video is much helpful.
@111hero11112 жыл бұрын
Thank you so much, That was helpfull
@paolobena Жыл бұрын
Wonderful video!!!!!
@huntercstephenson6 жыл бұрын
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
@michalroesler4 жыл бұрын
Good and informative video.
@laurynmoffa5 жыл бұрын
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"?
@muhammedwafa96465 жыл бұрын
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.
@kirstenfraser92936 жыл бұрын
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?
@wardellwhittaker8596 жыл бұрын
I get it. I just wish the codes to push the data was easier to write. But, I get it.
@nullhas4 жыл бұрын
Thank you. Sir, could you please show making this process with multiple data, i mean multiple pages..
@Izzzy_m Жыл бұрын
What is the benefit of using rich text content control vs plain text?
@palmbeachpropertybrothers97146 жыл бұрын
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.
@ErikLThoresen6 жыл бұрын
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
@kadnacer75715 жыл бұрын
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?
@xmatthys6 жыл бұрын
Great but it it possible to have the code in the notes ? ( easier to copy and avoid mistakes )
@Stef_426 жыл бұрын
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!
@akashdherange1202 жыл бұрын
Nice one can you do for excel to word
@bollyt53755 жыл бұрын
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
@abnh20035 жыл бұрын
شكرا
@Natta10875 жыл бұрын
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'
@Wacklewis5 жыл бұрын
Did you ever solve this issue? I’m getting the same error
@brad1511594 жыл бұрын
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
@brad1511594 жыл бұрын
All good. Fixed. Sorry for jumping the gun.My field containing the word document name had the (.docx) extension. Insert hand slapping on forehead here.Brad
@rahulbhedsurkar89936 жыл бұрын
Hey...Even though Liabarary is checked getting user defined error.. could you please advice how to go.
@Wacklewis5 жыл бұрын
Rahul Bhedsurkar did you ever get around this issue? I’m having the same problem
@jmacdragon6 жыл бұрын
I'm getting a subscript out of range error when I try to replicate this, any ideas what I may have missed?
@jedward1756 жыл бұрын
On your Excel file, rename your tab name with "Data".
@MrAurax246 жыл бұрын
you need to insert a module then insert a form command button if you want to click something to run the command otherwise you can skip the form command button just add a module copy the codes and run your macro.