Quote:
Originally Posted by mrlemmer11
I have already built a tool that through keystrokes, applies different comments where someone indicates.
|
Why would you build a tool for that, when Word already has a built-in comment facility?
Quote:
Originally Posted by mrlemmer11
After they are done, all the comments and their associations are extracted into excel.
|
You can get code to do this for Word's comments, at:
http://answers.microsoft.com/en-us/o...3-3131ab68809c
Quote:
Originally Posted by mrlemmer11
My question is this.... lets say a week later, someone decides they want to review/change some of those comments. How can I recreate that Document with all the comments located in order?
|
Perhaps you could explain why you think you'd need to recreate the document. Sure, you'd need to update the workbook, but why recreate the document? Surely you'd simply add the comments to the existing document, rather than making another one?
Quote:
Originally Posted by mrlemmer11
Obviously I the user can just save the form with their comments on it... however, as stated above we are talking about 40,000 documents, some 100 pages long already stored on a server somewhere. I don't think it's practical to resave all of these comment-applied documents again and use up all that space.
|
Instead of re-processing all documents, the only ones that would need re-processing are those with a save date later than the last date you updated the Excel workbook. Having identified those documents, it then becomes a matter of deleting any existing comments for them, then re-populating the workbook with the new details. Quite straightforward, really.