Using Macros in MS Word to Export Codes and Notes

By Keith Proctor, Training and Development Manager, CommTech

If you work with qualitative data, you know that managing data sources can be a real challenge. In a recent study, we collected a substantial amount of interview data that was transcribed into Microsoft Word. We then went through the Word documents coding different passages and themes. At the end of the process we needed a way to export the codes, notes, and passages for further analysis. The instructions below reflect how to use a macro to export comments.

  1. In Word, use "Comments" to highlight key passages.

    macro1.JPG
  2. In the comment, include your codes at the top and your notes below the codes.

    macro2.JPG
  3. In Word, access the Macros tool (In 2013 go to View > Macros).

    macro3.JPG
  4. Click “Create” to make a new macro.

    macro4.JPG
  5. This opens a new macro window.

    macro5.JPG
  6. Delete anything in the window and cut and paste the following instead (it should look like the picture below after you paste it):

    Sub exportcomments()
    Dim s As String
    Dim cmt As Word.Comment
    Dim doc As Word.Document
    For Each cmt In ActiveDocument.Comments
    s = s & "Code " & cmt.Index & " and Notes: " & cmt.Range.Text & vbCr & vbCr & "Quote " & cmt.Index & ": " & vbCr & Chr(34) & cmt.Scope & Chr(34) & vbCr & vbCr
    Next
    Set doc = Documents.Add
    doc.Range.Text = s
    End Sub

  7. Press the F5 function key or click “Run” at the top of the window. (You do not need to save before running the macro).

    macro6.JPG
  8. This creates and opens a new Word document with your comments, codes, and quotes. Now they can be exported, categorized, and analyzed based on your needs.

    macro7.JPG

 

 

 Comments

 
To add a comment, Sign In
Total Comments: 8
 
Mike posted on 11/13/2014 3:22 PM
Thanks for the tip, Keith! The tip is a creative way to leverage Word's functionality to categorize qualitative data.
Carolyn posted on 11/13/2014 4:30 PM
With a few modifications to fit my project, this tip will be very useful!
Lee posted on 11/14/2014 8:09 AM
Thanks Keith! Many of use macros in Excel, but are less familiar with their usage in Word. This tip is a great example of extending the functionality of macros within the Office environment.
Dale posted on 11/14/2014 12:03 PM
Thanks for the tip. Macros are great!
Ishuan posted on 11/14/2014 2:33 PM
Useful tip, thank you!
Shawn posted on 11/18/2014 11:17 AM
Extremely useful tip for helping to summarize qualitative results. Thanks for sharing!
Lisa posted on 11/18/2014 11:37 AM
I appreciate this tip! I haven't used macros much, but I've been wanting to learn more about them. This is timely because I have several qualitative projects on my horizon.
Lisa Ortiz posted on 11/22/2017 4:20 PM
Hello,

I just found this post and I’m hoping I can get some help despite how much time has transpired.

This process is really helpful, thanks! Is there a way to export codes in alphabetical order, or at least for the same codes to appear one after the other? For example, I have been creating comments by selecting text and writing the assigned code in the comment, without the word “Code”. Once the new document is created, I still have to then find everything under “aspirations,” for example, and then copy/paste to a new docjment, and so on and so forth so that all codes and quotes can be grouped together. I’m wondering if I can find an easier and less time-consuming way.

Thanks in advance,

Lisa