Exporting comments from word to excel - Comment.Parent property issue

		Microsoft Office Forums > Microsoft Word > Word VBA
Exporting comments from word to excel - Comment.Parent property issue

11-07-2023, 05:57 AM

DuchessNora DuchessNora is offline

Windows 11 Exporting comments from word to excel - Comment.Parent property issue

Office 2021

Novice

Join Date: Oct 2023

Posts: 6

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? :/

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Parent/Child Comment Extract	amschaefer	Word VBA	1	10-19-2023 11:41 PM
[Reviving solved thread for additional help] Exporting Tracked Changes and Comments to Excel	mjungli	Word VBA	4	01-11-2023 09:39 AM
Exporting Tracked Changes and Comments to Excel	alzasp	Word VBA	10	06-14-2022 02:13 AM
How to hide comments and comment indicators from OTHERS	Elena A	Excel	0	12-03-2014 12:08 PM
Exporting Word Comments into a pdf	blhowes	Word	5	01-09-2010 12:31 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:56 AM.