to Extract tracked changes and Comments from MS Word 2003 Document

Hi all,

Can anyone help me in creating the macro work for me?

I have created a macro in Word, to Extract tracked changes and Comments from MS Word 2003 Document and create a report in a new Excel Document.

The code works fine, except few things which I dont know how to do it.

Herewith, I have attached the code as a text file.

If you run this macro it will open a new Excel file and extract the revisions first and then comments.

I want to modify the macro so that it does the following:

1. The page number and the line number of the "comments" are not displaying properly (it displays as Page -1, Line -1) for all the entries

2. It should not extract the tracked changes in Page header and footer

3. It should not extract the changes in ToC

Please help me.