Hello All,
I am trying to write a macro which will split the comment. My supervisor wants to prioritize the comments. The comment text reads as below
Low : Comment 1
Medium : Comment 2
High: Comment 3
The out put should be displayed in an excel with the following headings
I was able to write a macro to export comments from words to an excel file. However, I am struggling to add this code snippet to split the comment text
Comment ID Page Section/Paragraph Name Comment Scope Comment text Priority Reviewer Comment Date
1 1 1.1heading1 example heading Comment 1 Low BlueDolphin 1/1/1
2 2 1.2heading example2 Comment 2 Medium BlueDolphin 1/1/1
3 3 1.3heading 3example3 Comment 3 High BlueDolphin 1/1/1
Anyhelp is much appreciated
Thanks
BlueDolphin