This one has me puzzled for some time, also because I don't know exactly how I can use the threaded comment function in VBA.
I have a workbook called "Questions.xls". I have 5 other workbooks that have fixed names (not going to list these names here, as not relevant) with various tabs.
Within the workbook "Questions" I would like to retrieve the threaded comments from all of the 5 files in one list. Info in the columns that I need is :
I have a workbook called "Questions.xls". I have 5 other workbooks that have fixed names (not going to list these names here, as not relevant) with various tabs.
Within the workbook "Questions" I would like to retrieve the threaded comments from all of the 5 files in one list. Info in the columns that I need is :
- First column gives the link to the location of the cell where the comment is (so it links to one of the 5 workbooks, specific tab, specific cell address)
- Second column is kind of specific. The comment that is written in the Threaded Comment, I would need all characters that are standing before the first colon. In other words, typically there is something like this in the threaded column : "Philippe : what is this amount ?", it would bring back "Philippe".
- Third column would bring back what's after the colon, in the above example : "what is this amount ?".
- Fourth column would bring back the first reply on the Threaded Comment.