export word review comments in excel

Anonymous
2010-10-08T09:36:15+00:00

Hi , I have several Review comments in my word documents, I wan to export all these comments to excel sheet.

If it is possible by macros, please guide me with step by step process.

Regards,

RG

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

45 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-02-03T13:52:10+00:00

    Hi Doug!  thank you very much for your quick response.  I am so sorry to trouble you but I have very limited knowledge on vba and excel/word macros.

    What I really want to pull into the excel is the actual words from the table columns to which the comments were tagged to.  Is it possible to do this?

    I am thinking that the Excel file will contain the same table as in the word but with the comments as a third column.

    Am very grateful for your help,

    Ailene

    Was this answer helpful?

    0 comments
  2. Doug Robbins - MVP - Office Apps and Services 323.6K Reputation points MVP Volunteer Moderator
    2015-02-03T04:58:49+00:00

    To get the table row number, use

    ActiveDocument.Comments(i).Range.Information (wdEndOfRangeRowNumber)

    But best to check that the comment is in a table by using

     checking to see if ActiveDocument.Comments(i).Range.Information(wdWithInTable) = True

    Was this answer helpful?

    0 comments
  3. Anonymous
    2015-02-03T02:57:22+00:00

    Hi, trying this code to get comments from a word document to excel.  How do I change the codes so that I get the row items from a word table with the matching comments?

    thank you very much,

    Ailene

    Was this answer helpful?

    0 comments
  4. Anonymous
    2014-10-31T09:26:52+00:00

    Many thanks for this excellent macro - saved me hours of work!

    Regards

    Johan

    Was this answer helpful?

    0 comments
  5. Anonymous
    2014-08-11T21:11:37+00:00

    MarkBowler7 on Page 2 is spot on with troubleshooting aldo's code on page 1. This works beautifully when compiling reviewer comments with their associated section headers, dates, page #s, etc into a spreadsheet. Saved the day for our team!

    Was this answer helpful?

    0 comments