Home Split Words in the comment text
Reply: 0

Split Words in the comment text

user856 Published in April 25, 2018, 12:19 pm

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.

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.365143 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO