HomeОбразованиеRelated VideosMore From: Harold Peach

Coding Text Using Microsoft Word

475 ratings | 98755 views
Describes how to use Word's comment feature to code text and then extract text segments to a table for analysis. The video uses a modified version of a Word macro available at http://www.thedoctools.com/index.php?show=mt_comments_extract
Html code for embedding videos on your blog
Text Comments (87)
Fonyuy Manjong (22 days ago)
Hello Harold, Thank You so much. That was 100% helpful to me.God Bless You
Nazri Noor (2 months ago)
This tutorial will make no sense to those who do not know what macro is, so do yourselves a favour and understand the basic functions of the macro.
Nazri Noor (2 months ago)
Well after an extensive amount of trial and error, I finally figure out the case of adding "line number". To include the line number just simply replace the 'author' line code with this code since I find it irrelevant to have such column on that; 'Line number .Cells(4).Range.Text = oDoc.Comments(n).Scope.Information(wdFirstCharacterLineNumber) please be reminded to edit (.Cells(4).Range.Text = "Author") in the insert heading section and change "author" to "line number" otherwise your "author" column will not change to "line number". I hope this helps.
Nazri Noor (2 months ago)
finally! so basically, you gotta paste the ready-made macro (in the bio) in your visual basic to actually extract the comments! thanks a lot!
Tom Shaw (3 months ago)
I want to thank you Harold. I used your technique recently to code around 40 long transcripts for a project in Afghanistan. It worked without a hitch and saved me a lot of money and time learning a new software. Simple and efficient. I would highly recommend. Cheers
Ghodsi Izadi (5 months ago)
Thank you so much Dr. Harold for your wonderful and helpful presentation. I have proudly cited you in my Chapter Four! .. But it seems many people have problems with extracting comments into a table format by Macro . Well ... I had the same problem and I devoted a great deal of time to know that I must have given the following command to my Microsoft Word. I found these invaluable pieces of information in the following Website prepared by "Penny Hickling" (I have already cited her in my thesis too!): https://answers.microsoft.com/en-us/office/forum/office_365hp-word/extract-comments-to-a-new-document-macro-including/e9394b78-875b-4319-aa40-d632b7c745f4 Dear Everyone, Please Give The Following Lengthy Command To Your Macros (Only for the Doc you are working on). .. Good Luck and keep up with the good work! : Sub ExtractCommentsToNewDocument() '========================= 'Macro created 2007 by Lene Fredborg, DocTools - www.thedoctools.com 'Revised October 2013 by Lene Fredborg: Date column added to extract 'THIS MACRO IS COPYRIGHT. YOU ARE WELCOME TO USE THE MACRO BUT YOU MUST KEEP THE LINE ABOVE. 'YOU ARE NOT ALLOWED TO PUBLISH THE MACRO AS YOUR OWN, IN WHOLE OR IN PART. '========================= 'The macro creates a new document 'and extracts all comments from the active document 'incl. metadata 'Minor adjustments are made to the styles used 'You may need to change the style settings and table layout to fit your needs '========================= Dim oDoc As Document Dim oNewDoc As Document Dim oTable As Table Dim nCount As Long Dim n As Long Dim Title As String Title = "Extract All Comments to New Document" Set oDoc = ActiveDocument nCount = ActiveDocument.Comments.Count If nCount = 0 Then MsgBox "The active document contains no comments.", vbOKOnly, Title GoTo ExitHere Else 'Stop if user does not click Yes If MsgBox("Do you want to extract all comments to a new document?", _ vbYesNo + vbQuestion, Title) <> vbYes Then GoTo ExitHere End If End If Application.ScreenUpdating = False 'Create a new document for the comments, base on Normal.dot Set oNewDoc = Documents.Add 'Set to landscape oNewDoc.PageSetup.Orientation = wdOrientLandscape 'Insert a 4-column table for the comments With oNewDoc .Content = "" Set oTable = .Tables.Add _ (Range:=Selection.Range, _ NumRows:=nCount + 1, _ NumColumns:=5) End With 'Insert info in header - change date format as you wish oNewDoc.Sections(1).Headers(wdHeaderFooterPrimary).Range.Text = _ "Comments extracted from: " & oDoc.FullName & vbCr & _ "Created by: " & Application.UserName & vbCr & _ "Creation date: " & Format(Date, "MMMM d, yyyy") 'Adjust the Normal style and Header style With oNewDoc.Styles(wdStyleNormal) .Font.Name = "Arial" .Font.Size = 10 .ParagraphFormat.LeftIndent = 0 .ParagraphFormat.SpaceAfter = 6 End With With oNewDoc.Styles(wdStyleHeader) .Font.Size = 8 .ParagraphFormat.SpaceAfter = 0 End With 'Format the table appropriately With oTable .Range.Style = wdStyleNormal .AllowAutoFit = False .PreferredWidthType = wdPreferredWidthPercent .PreferredWidth = 100 .Columns.PreferredWidthType = wdPreferredWidthPercent .Columns(1).PreferredWidth = 5 .Columns(2).PreferredWidth = 23 .Columns(3).PreferredWidth = 42 .Columns(4).PreferredWidth = 18 .Columns(5).PreferredWidth = 12 .Rows(1).HeadingFormat = True End With 'Insert table headings With oTable.Rows(1) .Range.Font.Bold = True .Cells(1).Range.Text = "Page" .Cells(2).Range.Text = "Code" .Cells(3).Range.Text = "Text" .Cells(4).Range.Text = "Interview" .Cells(5).Range.Text = "Date" End With 'Get info from each comment from oDoc and insert in table For n = 1 To nCount With oTable.Rows(n + 1) 'Page number .Cells(1).Range.Text = _ oDoc.Comments(n).Scope.Information(wdActiveEndPageNumber) 'The comment itself .Cells(2).Range.Text = oDoc.Comments(n).Range.Text 'The text marked by the comment .Cells(3).Range.Text = oDoc.Comments(n).Scope 'The comment author .Cells(4).Range.Text = oDoc.Comments(n).Author 'The comment date in format dd-MMM-yyyy .Cells(5).Range.Text = Format(oDoc.Comments(n).Date, "dd-MMM-yyyy") End With Next n Application.ScreenUpdating = True Application.ScreenRefresh oNewDoc.Activate MsgBox nCount & " comments found. Finished creating comments document.", vbOKOnly, Title ExitHere: Set oDoc = Nothing Set oNewDoc = Nothing Set oTable = Nothing End Sub
Meryem Essakhi (12 days ago)
How to use this please ?
Good help
Rak Ib (5 months ago)
Thank you very much Dr. Peach.
Bebe Okoli (6 months ago)
I've been trying this for days and it never worked, even when I followed the step by step instructions
Chris Byrne (9 months ago)
Brilliant I love it thanks :-)
Ntshiza M (11 months ago)
Great explanation. Thanks. Anyone requiring help with the macro, give me a shout. Managed to get it working
iris zhang (6 months ago)
There is no selection called 'ExtractCommentsToNewDoc' in the Macro as the video showed, Would you please help me?
gracemwaura (7 months ago)
Trying to get it work on Mac. Kindly help
Hotaruu (1 year ago)
Great for expert interviews with a small sample size like mine (N = 20). Thank you so much for sharing.
Adesina Abegunde (1 year ago)
Dr Harold, thanks so much for this video. It worked! God bless you real good.
Kirubel Mussie (1 year ago)
This video is super!!! It solved the problem with the too many codes I have! Thanks a lot!
Tom Lynch (1 year ago)
worked great
Charith Suranga (1 year ago)
Hi guys I did comments and tries use macros to extract comments in new doc. New doc is not creating. Can anyone help me? Read all comments tried but not work? any advice ?
MegaKachTV (1 year ago)
hello... please, can coding be also called categorizing???
MegaKachTV (1 year ago)
Dear Dr. Harold, thank you very much for this video. I have been struggling with but you have come to my rescue.Please, do you have a video on how to use the Nvivo?
Eliza (1 year ago)
This is great....didn't find the macro you used, but did learn about them here: 1) If your version of Word doesn’t have the ExtractCommentstoNewDoc macro, you can find it here: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_word-mso_windows8-mso_365hp/extract-comments-to-a-new-document-macro-including/e9394b78-875b-4319-aa40-d632b7c745f4?auth=1 2) And to create a new macro (did a celebratory dance at my desk when it worked!), see: https://support.office.com/en-us/article/create-or-run-a-macro-c6b99036-905c-49a6-818a-dfb98b7c3c9c
Piunjqeur Dktlvz (1 year ago)
Guys who need office 2016 product key can go to page #plus.google.com/u/0/collection/koUdIE get one, works like a charm!
Thomas Erler (1 year ago)
Hi, WHO CAN HELP to implement and use this macro in WORD for MAC 2011. Unfortunately I am not experienced in working with macros...  Thank you very much in advance !!!!
Syahrir Zaini (1 year ago)
I added the Line No. You can copy and paste this code into the visual basic: Public Sub ExtractCommentsToNewDoc() '========================= 'Macro created 2007 by Lene Fredborg, DocTools - www.thedoctools.com 'Revised October 2013 by Lene Fredborg: Date column added to extract 'THIS MACRO IS COPYRIGHT. YOU ARE WELCOME TO USE THE MACRO BUT YOU MUST KEEP THE LINE ABOVE. 'YOU ARE NOT ALLOWED TO PUBLISH THE MACRO AS YOUR OWN, IN WHOLE OR IN PART. '========================= 'The macro creates a new document 'and extracts all comments from the active document 'incl. metadata 'Minor adjustments are made to the styles used 'You may need to change the style settings and table layout to fit your needs '========================= Dim oDoc As Document Dim oNewDoc As Document Dim oTable As Table Dim nCount As Long Dim n As Long Dim Title As String Title = "Extract All Comments to New Document" Set oDoc = ActiveDocument nCount = ActiveDocument.Comments.Count If nCount = 0 Then MsgBox "The active document contains no comments.", vbOKOnly, Title GoTo ExitHere Else 'Stop if user does not click Yes If MsgBox("Do you want to extract all comments to a new document?", _ vbYesNo + vbQuestion, Title) <> vbYes Then GoTo ExitHere End If End If Application.ScreenUpdating = False 'Create a new document for the comments, base on Normal.dotm Set oNewDoc = Documents.Add 'Set to landscape oNewDoc.PageSetup.Orientation = wdOrientLandscape 'Insert a 6-column table for the comments With oNewDoc .Content = "" Set oTable = .Tables.Add _ (Range:=Selection.Range, _ NumRows:=nCount + 1, _ NumColumns:=6) End With 'Insert info in header - change date format as you wish oNewDoc.Sections(1).Headers(wdHeaderFooterPrimary).Range.Text = _ "Comments extracted from: " & oDoc.FullName & vbCr & _ "Created by: " & Application.UserName & vbCr & _ "Creation date: " & Format(Date, "MMMM d, yyyy") 'Adjust the Normal style and Header style With oNewDoc.Styles(wdStyleNormal) .Font.Name = "Arial" .Font.Size = 10 .ParagraphFormat.LeftIndent = 0 .ParagraphFormat.SpaceAfter = 6 End With With oNewDoc.Styles(wdStyleHeader) .Font.Size = 8 .ParagraphFormat.SpaceAfter = 0 End With 'Format the table appropriately With oTable .Range.Style = wdStyleNormal .AllowAutoFit = False .PreferredWidthType = wdPreferredWidthPercent .PreferredWidth = 100 .Columns.PreferredWidthType = wdPreferredWidthPercent .Columns(1).PreferredWidth = 5 .Columns(2).PreferredWidth = 5 .Columns(3).PreferredWidth = 23 .Columns(4).PreferredWidth = 41 .Columns(5).PreferredWidth = 16 .Columns(6).PreferredWidth = 10 .Rows(1).HeadingFormat = True End With 'Insert table headings With oTable.Rows(1) .Range.Font.Bold = True .Cells(1).Range.Text = "Page" .Cells(2).Range.Text = "Line" .Cells(3).Range.Text = "Textual Data" .Cells(4).Range.Text = "Code" .Cells(5).Range.Text = "Coder" .Cells(6).Range.Text = "Date" End With 'Get info from each comment from oDoc and insert in table For n = 1 To nCount With oTable.Rows(n + 1) 'Page number .Cells(1).Range.Text = _ oDoc.Comments(n).Scope.Information(wdActiveEndPageNumber) 'Line number - start of revision .Cells(2).Range.Text = _ oDoc.Comments(n).Scope.Information(wdFirstCharacterLineNumber) 'The text marked by the comment .Cells(3).Range.Text = oDoc.Comments(n).Scope 'The comment itself .Cells(4).Range.Text = oDoc.Comments(n).Range.Text 'The comment author .Cells(5).Range.Text = oDoc.Comments(n).Author 'The comment date in format dd-MMM-yyyy .Cells(6).Range.Text = Format(oDoc.Comments(n).Date, "dd-MMM-yyyy") End With Next n Application.ScreenUpdating = True Application.ScreenRefresh oNewDoc.Activate MsgBox nCount & " comments found. Finished creating comments document.", vbOKOnly, Title ExitHere: Set oDoc = Nothing Set oNewDoc = Nothing Set oTable = Nothing End Sub
Lukáš Michálek (1 year ago)
Thanks! it works!
edwin rwigi (1 year ago)
Thanks Zaini, this helped a great deal!
Thomas Snowjink (1 year ago)
Dr Harold. Thank you so much for this video. It actually helped me tremendously in conducting my research thesis.
Thanks very useful. I used the link mentioned by Mad5cout and it worked
Simulation Developer (1 year ago)
Thanks Harold! I would LOVE to know if I could code my Themes in the Comments area in a way that - after extracting them into a table - would put the categories across the top and the variables down the left side? As a very low-tech user, I can just manage to create graphs from tables in Word, but I can't get my codes into the tables automatically (only manually). If you know how I could use commas or paragraph markers etc. to automatically place my Comments in the right parts of table, it would let me stay in Word for all my coding and graph production.
Dr. Oscar Mostofi (1 year ago)
Where is the coding macro? When I view the macro, there is none.
M Riaz (1 year ago)
this is a useful macro - does anyone know how to add a page number in the footer of the new document? thanks
itsyoussef (1 year ago)
Great. Thank you.
Petcu Cristina (2 years ago)
Thank you very much for the tool Mr. Peach! Very very useful!
Piers Pearson (2 years ago)
Brilliant help. It won't let me run though?
Koos van der Hoeven (2 years ago)
Great, thank to al reviews i find the solution.
Koos van der Hoeven (2 years ago)
Great thanks, but it does not show the line number
Tyler Nethercott (2 years ago)
This is AWESOME!
Mahmoud Assaad (2 years ago)
Thank you Harold. That was so helpful.
Dora Duan (2 years ago)
Hi, Harold, My Word couldn't run the macro. I create the name for the macro as 'ExtractCommentsToNewDoc', and then I click 'Run', but no new doc. was created. Could you help me?
游捷 (1 month ago)
hi i found that we have to "build" a new macro at the first time. This website can help us. https://www.thedoctools.com/word-macros-tips/word-macros/extract-comments-to-new-document/ It already have the ''extract macro" code. (https://www.thedoctools.com/downloads/basComments_Extract.htm We can just copy and paste the code when we start this new macro. Many thanks to this website.
Harerimana Alexis (1 year ago)
I experienced the same problem.
Cynthia Agatha Asingwa (2 years ago)
Thank you. I've found the information very useful.
Khayrul Basar (2 years ago)
very useful but it did not work for my document.
Mad5cout (2 years ago)
For those trying to figure out how to add this, this is the process I used and it worked. First, go to this link to the HTML text of the macro: http://www.thedoctools.com/downloads/basComments_Extract.htm Second, open the word doc you want to run it on. Go to View. Hit Macros. Go to View Macros. Put ExtractComments or w/e title you want in the Macro Name field. Hit "Create' this will bring you into a Macro editor. Paste the coding text from the HTML link into the macro file in the editor below the ' signs. Save this and exit the Macro editor and then you are done. Not sure if that is how Harold Peach would do it but it works. Good luck everyone.
Ngoc Hoa Nguyen (1 year ago)
Thank you so so much!! This is absolutely helpful for me!
Kirubel Mussie (1 year ago)
Thanks! This was also helpful!
nicole Jackson (1 year ago)
Thank you, so much this worked perfectly for me.
Daniel Mususa (2 years ago)
This isnt working. I have followed the steps above in the macros editor, saved but when I hit "run" it says "Compile error: Expected list separator or )". How do I rectify that
Charlie Hill (2 years ago)
This is super helpful and works really well. For anyone wondering why your word document does not have 'extract command' in macros you need to modify your document by downloading the free add-in suggested in the authors description box. Thank you for the instruction it really has helped.
Joe Elliott (2 years ago)
How did you edit your macro so that the line number is displayed with the page number, in the table?
Priscilla Kora (2 years ago)
Hello, Wonderful video, but i couldn't execute it because i didn't have the right macro. do you have a special macro for the extraction of the comments? Thanks
kimsorn Ngam (2 years ago)
What version are you using in presentation? I followed but once I macros it there was no file in it feature. What can I do? Your presentation is really helpful for my career.
Karen Stovall (2 years ago)
This is an excellent video and i have read the comments below and I used to write code for computers however, I am lost. Can you help?
Naheed Arshad (2 years ago)
hello Harold have just worked it out using doc tools. but my extracted data is page numbers. can't change it any other way how can i do this? even when i put line numbers in original document it still only extracts to show page numbers. please advice
Naheed Arshad (2 years ago)
hello harold i am not good with computers. but i think someone has posted a code in comments. i have transcribed my interview and coded with comments as advised . i need to extract the comments from my word document into a new document. can you advise me step by step how to do this. i would be very grateful. thank you
Mattias Morrison (2 years ago)
Dr. Peach, THANK YOU! I have OS X Word 2011. The initial install didn't work, however I was able to cut/paste the macro from the website, then tweak it for my table column headings. Watching your workflow was been very helpful to me and a few of my classmates.
David J (3 years ago)
Hi Harold great tutorial, as I am a novice to coding transcripts. I have got the macro working on my mac but for some reason it doesn't extract the textual data that I have selected for the comment. Did you make a change to the macro to include this?
Laura B (3 years ago)
Hello, I have a problem :( using word 2011 for mac, when I want to run the macro on my document it gives me an error : Compile error in hidden module: DED_ExtractComments what should I do??
Patrick Kaeslin (3 years ago)
Hi Harold, this is a great presentation of coding. Would you mind to present your modified version of this word macro? Thanks in advance.
Nattawadee Tarasena (1 year ago)
It works perfectly. Thanks a bunch.
Koos van der Hoeven (1 year ago)
Great it works, many thanks
mgcains (1 year ago)
Hello Koos. I modified the macro to include the line number and retain the comments section. The original code only had five columns created so a sixth column must be created to allow for the line number to be added. Below after the *** is the modified macro with line number AND comments. *** Public Sub ExtractCommentsToNewDoc() '========================= 'Macro created 2007 by Lene Fredborg, DocTools - www.thedoctools.com 'Revised October 2013 by Lene Fredborg: Date column added to extract 'THIS MACRO IS COPYRIGHT. YOU ARE WELCOME TO USE THE MACRO BUT YOU MUST KEEP THE LINE ABOVE. 'YOU ARE NOT ALLOWED TO PUBLISH THE MACRO AS YOUR OWN, IN WHOLE OR IN PART. '========================= 'The macro creates a new document 'and extracts all comments from the active document 'incl. metadata 'Minor adjustments are made to the styles used 'You may need to change the style settings and table layout to fit your needs '========================= Dim oDoc As Document Dim oNewDoc As Document Dim oTable As Table Dim nCount As Long Dim n As Long Dim Title As String Title = "Extract All Comments to New Document" Set oDoc = ActiveDocument nCount = ActiveDocument.Comments.Count If nCount = 0 Then MsgBox "The active document contains no comments.", vbOKOnly, Title GoTo ExitHere Else 'Stop if user does not click Yes If MsgBox("Do you want to extract all comments to a new document?", _ vbYesNo + vbQuestion, Title) <> vbYes Then GoTo ExitHere End If End If Application.ScreenUpdating = False 'Create a new document for the comments, base on Normal.dotm Set oNewDoc = Documents.Add 'Set to landscape oNewDoc.PageSetup.Orientation = wdOrientLandscape 'Insert a 6-column table for the comments With oNewDoc .Content = "" Set oTable = .Tables.Add _ (Range:=Selection.Range, _ NumRows:=nCount + 1, _ NumColumns:=6) End With 'Insert info in header - change date format as you wish oNewDoc.Sections(1).Headers(wdHeaderFooterPrimary).Range.Text = _ "Comments extracted from: " & oDoc.FullName & vbCr & _ "Created by: " & Application.UserName & vbCr & _ "Creation date: " & Format(Date, "MMMM d, yyyy") 'Adjust the Normal style and Header style With oNewDoc.Styles(wdStyleNormal) .Font.Name = "Arial" .Font.Size = 10 .ParagraphFormat.LeftIndent = 0 .ParagraphFormat.SpaceAfter = 6 End With With oNewDoc.Styles(wdStyleHeader) .Font.Size = 8 .ParagraphFormat.SpaceAfter = 0 End With 'Format the table appropriately With oTable .Range.Style = wdStyleNormal .AllowAutoFit = False .PreferredWidthType = wdPreferredWidthPercent .PreferredWidth = 100 .Columns.PreferredWidthType = wdPreferredWidthPercent .Columns(1).PreferredWidth = 5 .Columns(2).PreferredWidth = 5 .Columns(3).PreferredWidth = 20 .Columns(4).PreferredWidth = 40 .Columns(5).PreferredWidth = 18 .Columns(6).PreferredWidth = 12 .Rows(1).HeadingFormat = True End With 'Insert table headings With oTable.Rows(1) .Range.Font.Bold = True .Cells(1).Range.Text = "Page" .Cells(2).Range.Text = "Line" .Cells(3).Range.Text = "Comment scope" .Cells(4).Range.Text = "Comment text" .Cells(5).Range.Text = "Author" .Cells(6).Range.Text = "Date" End With 'Get info from each comment from oDoc and insert in table For n = 1 To nCount With oTable.Rows(n + 1) 'Page number .Cells(1).Range.Text = oDoc.Comments(n).Scope.Information(wdActiveEndPageNumber) 'Line number .Cells(2).Range.Text = oDoc.Comments(n).Scope.Information(wdFirstCharacterLineNumber) 'The text marked by the comment .Cells(3).Range.Text = oDoc.Comments(n).Scope 'The comment itself .Cells(4).Range.Text = oDoc.Comments(n).Range.Text 'The comment author .Cells(5).Range.Text = oDoc.Comments(n).Author 'The comment date in format dd-MMM-yyyy .Cells(6).Range.Text = Format(oDoc.Comments(n).Date, "dd-MMM-yyyy") End With Next n Application.ScreenUpdating = True Application.ScreenRefresh oNewDoc.Activate MsgBox nCount & " comments found. Finished creating comments document.", vbOKOnly, Title ExitHere: Set oDoc = Nothing Set oNewDoc = Nothing Set oTable = Nothing End Sub
Koos van der Hoeven (2 years ago)
When I perform this modification, the line number appears (great) but the comments disappears.
GL Lee (2 years ago)
Patrick, where should the modification be made? I tried using the Edit feature and added the line above but it didn't work. Appreciate your guidance. Thanks.
Dionne Barnes-Proby (3 years ago)
How do you get the line numbers in the table? The are not included in the macro.
D S (1 year ago)
But where is the problem.
Warren Yamashita (2 years ago)
+Harold Peach, thank you for the video! Super helpful. But can you or anyone tell us where to enter this? 'Line number .Cells(2).Range.Text = oDoc.Comments(n).Scope.Information(wdFirstCharacterLineNumber)
Maria Alonso (2 years ago)
Hello Harold! I'm currently going through the same productive struggle as Samantha.  Can you tell me where exactly I have to add     'Line number             .Cells(2).Range.Text = oDoc.Comments(n).Scope.Information(wdFirstCharacterLineNumber)? This is such a great resource!  I'm was feeling overwhelmed with my mixed methods data analysis. I'll be sharing this gem of knowledge with my classmates.  Thank you!!!
GL Lee (2 years ago)
Dr Harold, where should the modification be made? I tried using the Edit feature and added the line above but it didn't work. Appreciate your guidance. Thanks.
Harold Peach (3 years ago)
+Dionne Barnes-Proby 'Line number .Cells(2).Range.Text = oDoc.Comments(n).Scope.Information(wdFirstCharacterLineNumber)
Camila Torres (3 years ago)
the version on the doctools.com does not have the code for line number.  Is there a way to add it easily?
elise wood (1 year ago)
I had the same problem
Yogesh S Atray (3 years ago)
hi i find this video very useful. Thank you for uploading. but i am unable to use this feature in my Document. does it require any macro to download. i have no clue. kindly help
Gökçen Bulut (3 years ago)
+Harold Peach The link is empty; can you recommend another one to be used in Mac as well? By the way the video is quite useful that thank you for it!!
Harold Peach (3 years ago)
+Yogesh S Atray Yes, See the description above for a link to the original macro. You will need to add this macro to your Word document and modify it to meet your specific needs.
Harold Peach (3 years ago)
I have not personally tested this, but I believe it works in Word 2010 for the Mac, but not in earlier versions.
Dana Ng (3 years ago)
I guess this only works for Windows, but not Mac...I couldn't get it to work
Harold Peach (3 years ago)
+Dana Ng it should work with the latest version of Office for the Mac, but not with older versions.
Cristina Vila (4 years ago)
Really useful. Thanks
Camila Torres (4 years ago)
I need!  How do I download this macro? I can't figure it out!
Eli Shokribavil (1 year ago)
Could you please help me to figure out how I can add line number to the Extracting Macro?
Naheed Arshad (2 years ago)
Camila can you advise me step by step how did you do this not good with computers. i have transcribed my interview, coded with comments but need to extract the comments on a separate word document. please help
Siena Del Rio (3 years ago)
+Camila Torres I can't figure it out how to download this! Can someone help??
Camila Torres (4 years ago)
I figured it out and I am rocking and rolling! Thanks!

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.