Export Word Comments To Excel - How to use a macro to export comments from word to an excel document. In this article, you learn a handy way to extract comments from a word document into excel using a vba code. Web .cells(i + headingrow, 4).formula = activedocument.comments(i).range.cells(i + headingrow, 5).formula = activedocument.comments(i).initial.cells(i + headingrow, 6).formula = format(activedocument.comments(i).date, dd/mm/yyyy).cells(i + headingrow, 7).formula = activedocument.comments(i).range.listformat.liststring. 'set a reference to the excel object library. Web at the top of the macro you will see the instruction. Web export comments from word to excel. Sub copycommentstoexcel () 'create in word vba. 36k views 3 years ago. If you have several comments in your word documents, and you want to extract these comments from word to excel sheet, then you are in the right place. This means that from the vba editor you should select tools > references and check the box against microsoft excel.
This means that from the vba editor you should select tools > references and check the box against microsoft excel. If you have several comments in your word documents, and you want to extract these comments from word to excel sheet, then you are in the right place. 36k views 3 years ago. Web .cells(i + headingrow, 4).formula = activedocument.comments(i).range.cells(i + headingrow, 5).formula = activedocument.comments(i).initial.cells(i + headingrow, 6).formula = format(activedocument.comments(i).date, dd/mm/yyyy).cells(i + headingrow, 7).formula = activedocument.comments(i).range.listformat.liststring. Sub copycommentstoexcel () 'create in word vba. How to use a macro to export comments from word to an excel document. Web export comments from word to excel. In this article, you learn a handy way to extract comments from a word document into excel using a vba code. Web at the top of the macro you will see the instruction. 'set a reference to the excel object library. Web is it possible to export the comments made on word in revision mode in an excel file?