Possible to export Word track changes information to Excel spreadsheet

Hi all

Is it possible to import/export the track changes information in a Word file (2007 or 2010) to an excel spreadsheet

Koob
|
Answer
Answer

Also look at this link:

http://www.thedoctools.com/index.php?show=mt_trackchanges_extract

It appears that the resulting document will be a Word table, which you could copy to Excel.

2 people found this reply helpful

Was this reply helpful?

Yes
No

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Answer
Answer
Hi all

Is it possible to import/export the track changes information in a Word file (2007 or 2010) to an excel spreadsheet

Koob


The following macro could be modified to write the text of the revisions to another document or to an Excel Workbook

Dim arev As Revision
With ActiveDocument
    For Each arev In .Revisions
        If arev.Type = wdRevisionDelete Then
            MsgBox "The following text was deleted: " & arev.Range.Text
        ElseIf arev.Type = wdRevisionInsert Then
            MsgBox "The following text was inserted: " & arev.Range.Text
        End If
    Next arev
End With

Note, however that there are many more Revision.Types that just the Delete and Insert.

Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com
It's time to replace ‘Diversity, Equity & Inclusion’ with ‘Excellence, Opportunity & Civility’ - V Ramaswamy

1 person found this reply helpful

Was this reply helpful?

Yes
No

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated August 15, 2021 Views 23,260 Applies to: