-
Split Words in the comment text - VBA Macro
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
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules