Thread: Exporting comments from word to excel - Comment.Parent property issue
View Single Post
 
Old 10-25-2023, 05:36 AM
Italophile Italophile is offline Windows 11 Office 2021
Expert
  
Join Date: Mar 2022
Posts: 341
Italophile is just really niceItalophile is just really niceItalophile is just really niceItalophile is just really nice
Default
You would replace
Code:
StrCmt = StrCmt & vbTab & IIf(.Parent Is Nothing, "Not a Parent", "Is a Parent")
with:
Code:
StrCmt = StrCmt & vbTab & IIf(.Ancestor Is Nothing, "Not a Parent", "Is a Parent")
Reply With Quote