How to Export Word Comments into a Coding Table Fast (Full Transcript)

[00:00:00] Speaker 1: One of the challenges sometimes we face is after coding the data using Microsoft Word, we always have a list of code here and we find it very difficult for us to compile all the codes. I'm going to show you how to compile all your codes after you have coded your data using Microsoft Word, right. So let's say you are doing a manual code and you have gone through all the transcript identifying information that are significant and develop codes like what I have here. How do you move from having code and having a table like this with all the quotations and also all the codes? How do you do that? The longer version which is very challenging to do is to just copy and paste each of the codes on the page. Copy this one and go here and put the code here and then go to the next one. Let's say you have about 20 or 30 codes. You have to copy each of them and bring it here. It takes a long time for you to do that. What is the efficient way of doing it? Let me show you. So in order to solve this problem, I went to Perplexity AI and I asked the system this question that I want to compile all comments on my Word document. What is the best way to copy all the comments at the same time and put them on another Word document? The system provided me some suggestions and also provided me VBA macro code. So this VBA macro code is what I'm going to use to help me to create a table with all the quotations and also all the codes that I've created on a Word document. So I'm going to give you the step-by-step. It's so easy to do. One thing I'm going to do is that in the description is that I'm going to put this code there so that you just copy and paste it and then you'll be able to get your table with all the quotations and also the codes and so that you'll be able to move to the next stage of the analysis. So let's go back to the document. So what you have to do is that you first have to press on alt f11. So when you do that this window opens. So I have this window here. It's very different from the main one and then you go to insert. You are not using the insert on the main document here. You are using the insert on this window. Go to insert and go to module and then you can copy this code. You don't have to understand what is here but it works. Copy this code and go back here and paste this code here and close it. Then when you are done closing it you go to run and then you go to run macro. Click on that and click on run and then within a few seconds you get all your lists. After that you just have to close this window because we're finished with that and then you have on a new document you have a list of all your quotation and the commented test. All these are the quotation and also all these are the quotes right. So you have all the quotes here and the quotation and it also gives you the time that you did a quote and also the author is Philip Edu and then the number of quotes. So you can see here that I have about 26 quotes right. So this is the easier way of compiling all your codes so that you can move to the next process of categorizing the codes and developing themes. I hope this one was helpful. If you have any questions feel free to put your question in the comment section. I'll be happy to respond. Don't forget to subscribe to my channel. Thank you for your time.