I am trying to write a macro which will split the comment. My supervisor wants to prioritize the comments, e.g.:
Low : Comment 1
Medium : Comment 2
High: Comment 3
The output should be displayed in Excel with the following headings.
I was able to write a macro to export comments from Word 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|
Any help is much appreciated.