Export Comments with referred text and line numbers from Word to Excel

[Copkay123]

I am complete novice on VBA but I have followed the code in the thread and the modifications to include sections and headings.

Export Comments with referred text and line numbers from Word to Excel

StrCmt = StrCmt & vbTab & .Scope.GoTo(What:=wdGoToBookmark, Name:="\HeadingLevel").Paragraphs.First.Range.ListFormat.ListString
StrCmt = StrCmt & vbTab & .Scope.GoTo(What:=wdGoToBookmark, Name:="\HeadingLevel").Paragraphs.First.Range.Text

The above works like magic, but what modification I should do to extract the Heading Level 2. i tried modifying above to lines to wdGotoHeading but it didn't work and threw error on Bookmark not found

 

[Joe4]

Duplicate to: Export Comments with referred text and line numbers from Word to Excel

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.