Skip to main content

Posts

Showing posts with the label Track Revisions using VBA

How to get Author details from Track Changes using VBA

Word VBA - extract Revision Author information If you want to know the details of track revisions, for example, Author name etc the following code will help you: Sub Get_TrackRevision_Author() Dim oRev As Revision Dim oRange As Range ' ----------------------------------------------------------- ' Change the line below to suit your needs ' ----------------------------------------------------------- Set oRange = Selection.Range ' ----------------------------------------------------------- ' Coded by Shasur for http://vbadud.blogspot.com ' ----------------------------------------------------------- For Each oRev In oRange.Revisions MsgBox oRev.Range.Text & " " & oRev.Author Next oRev End Sub The following code provides you more information (like if the comment is inserted / deleted) If oRev.Type = wdRevisionDelete Then MsgBox oRev.Range.Text & " deleted by " & oRev.Author ElseIf oRev.Type = wdRevisionInsert Then ...

Facebook

Facebook Recommendations

Followers


Web Designing In Karachi



Haroof.com


Politics blogs

My Zimbio

Email Subscribe

Enter your email address:

Watch online Live TV

Labels

Show more