export word review comments in excel

The macro would have worked in Word 2013 as it stood originally - but you overlooked the instruction at the top of the macro

Sub CopyCommentsToExcel()

'Create in Word vba

'set a reference to the Excel object library

Dim xlApp As Excel.Application

Dim xlWB As Excel.Workbook

The macro uses early binding to Excel, so you have to set a reference to the Excel object library to provide the command set. You alternative uses Late Binding so does not need the reference, and in the code example there are no Excel specific instructions so it will work without further changes.

Thank you very much for the Code. It works perfectly !!

Use Graham Mayor's code.

My first question was not clear, so here it is again:

When I run the macro on a Word document that contains comments, I get the following message: "Compile error: Method or data member not found."

The code stops at this line in the ParentLevel function: sStyle = Para.Range.ParagraphStyle. The word "ParagraphStyle" is highlighted.

Could anybody help me figure out why the macro breaks?

Thanks in advance.

Aldoduke's answer seems fine if headings have numbers. What if headings DON'T have numbers? How would I change the code of this macro?