Linking an Excel Snag List to the Comments in a Word File

[prephil]

Is it possible to link an Excel file to the comments being generated in a Word file? I have a situation at work where we have a Word document that is being used by several different people who are adding comments to it.

One of the guys is using an Excel file to create a snag list of issues based on these Word comments. I can understand why - it is very easy to see all the comments in one place line by line whereas Word is not so easy on the eye in this department, at least not in a way i know of.

So my question is, is it possible to link the Word & Excel files so that any comments that are entered in the Word file are automatically put into the Excel file. Anytime the Word file gets updated, i.e. new comments are added, the Excel file updates automatically also to show these new comments. An additional requirement, although not essential would be to have information like the page number the comment appears on in the Word file, auto arrange comments based on the page number they appear (could be filtered/arranged anyway based on page number), name of person who entered the comment, date of comment....

 

[Gerald Higgins]

This is probably do-able, but if it was me I think I would just do the whole thing in Excel.

 

[prephil]

Do you have any tips on how to make it doable by any chance?

 

[Gerald Higgins]

Well I've never done it myself so I can't give detailed instructions.
But when I used the search function on this board, using the terms EXCEL, WORD, LINK, FILES, it came up with lots of results, some of these may be helpful to you.

But seriously, consider doing it in just one package, either Excel or Word, not both, and I would definitely use Excel.

 

[prephil]

Thanks Gerald I appreciate your feedback. You are probably correct.