Ask a new question

Is it possible to combine the "balloon comments" created by people from two separate word files?

Hi there,

By comments I mean the "balloon comments" on the side that people create and not the actual document text changes.

I know how to combine text changes etc.. but don't see a way to merge the balloon comments.

Instead of viewing individual documents with balloon comments from people, I'd like to be able to see everyone's

balloon comments on one document.

Thanks for the help!

Answer
Answer

The following will create a new document containing the comments from the two individual  documents:

Dim SourceA As Document, SourceB As Document, Target As Document
Dim i As Long
Set SourceA = Documents.Open("[insert path and filename of first document containing comments]")
Set SourceB = Documents.Open("[insert path and filename of second document containing comments]")
Set Target = Documents.Add
With SourceA
    For i = 1 To .Comments.count
        Target.Range.InsertAfter .Comments(i).Range.Text & vbCr
    Next i
End With
With SourceB
    For i = 1 To .Comments.count
        Target.Range.InsertAfter .Comments(i).Range.Text & vbCr
    Next i
End With
Target.Activate

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

Was this reply helpful?

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 October 5, 2021 Views 841 Applies to: