Microsoft Office Forums - View Single Post - Exporting comments from word to excel

DuchessNora · 11-07-2023, 05:57 AM

Quote:

Originally Posted by Italophile

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")

Hi, I tried replacing this but it still classes the parent comment as not a parent? :/