Tracking Changes in Word Using Excel

[rahul4real]

I need to track the changes made in a word document namely the normal
addition, deletion of text, adding comments, etc .. There is a feautre
in Word which can do this Tools --> Review --> Track Changes. I guess
word makes a seperate tmp file which stores all the changes made.

What I need is somehow whatever changes we make in the Word document
gets stored in a excel sheet. Maybe somehow exporting all the metadata
stored in the tmp file to the excel sheet ?!

Please Help!

 

[Doug Robbins - Word MVP]

Word does not make a separate temp file.

Use the following as a starting point:

Dim arev As Revision
Dim revtype As String
With ActiveDocument
For Each arev In .Revisions
Select Case arev.Type
Case 1
revtype = " was inserted in line "
Case 2
revtype = " was deleted from line "
End Select
MsgBox Chr(34) & arev.Range.Text & Chr(34) & revtype &
arev.Range.Information(wdFirstCharacterLineNumber) & " on page " &
..Range.Information(wdActiveEndPageNumber)
Next arev
End With



--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

 

[DeanH]

Also see
http://www.thedoctools.com/index.php?show=mt_trackchanges_extract
which produces a Word table of all changes (Insertions/Deletions only),
which you could transfer to Excel.
Hope this helps
DeanH

 

[rahul4real]

Also see
'DocTools - VBA Macros and Code Snippets for Microsoft Word - <?php
include(\"us/mt_trackchanges_extract_title.php\"); ?>'
(http://www.thedoctools.com/index.php?show=mt_trackchanges_extract)
which produces a Word table of all changes (Insertions/Deletions
only),
which you could transfer to Excel.
Hope this helps
DeanH

Hi, thanks a lot for this link. Can you also tell me how to export the
word file that this macro makes into an excel file ? luv
Thanks.

 

[DeanH]

Not so much of convert, but copy/paste.
Select the Word table that is created, copy. Go to Excel, paste. Edit as you
see fit.
Hope this helps
DeanH