Lene Fredborg, DocTools, har hvert år siden 2008 modtaget den prestigefyldte pris som Microsoft Most Valuable Professional (MVP) i Word – link til information om MVP Award'en DocTools - dokumentautomatisering - add-ins, makroer og skabeloner til Microsoft Word (logo) Dokumentautomatisering
Add-ins & Makroer
Skabeloner
Til Microsoft Word
Dokumentautomatisering, skabeloner (templates), add-ins og makroer til Microsoft Word (grafik)



Bogmærk denne side | Tip en ven om DocTools


Søg thedoctools.com:

Custom Search



Macro and add-in ready for use...

Macro – Extract Comments to New Document

If a document contains many comments (inserted via Review tab > New Comment), you may wish to get an overview of all the comments in one place. Here you will find both a macro and a free Word add-in that lets you extract all the comments to a new document.

Revised October 2013
The macro now includes an extra column showing comment dates.

Terms of use

You are welcome to use the macros and Word tips provided on this website. The contents is copyright. You may not reproduce any of contents (with or without modification or credits) elsewhere on the web, or on CD. Please link to the contents on this website instead.

Please note that all free Word tips, macros, add-ins and demos are provided "as is" and without obligation. See also detailed Terms of use.


Instead of installing the macro available on this page you may be interested in the ready-to-use add-in, DocTools ExtractData.


Go to info about DocTools ExtractData – free add-in
Go to macro solution


Free Word add-in that lets you extract
acronyms, bookmarks, tracked changes and comments


DocTools ExtractData - a free add-in for Word

Word add-in from DocTools

DocTools ExtractData is an add-in for Microsoft Word that is provided free of charge.

The add-in works with Microsoft Word 2007, 2010, 2013, 2016 on PC.

The add-in lets you easily extract the following types of data from the active document to a new document:

Bulletacronyms

Bulletbookmarks

Bullettracked changes

Bulletcomments

The extracted data, incl. additional metadata, will be listed in a table for easy overview.

DocTools ExtractData adds a set of tools to a custom tab, DocTools, in the Ribbon. The tools can be accessed from the group Extract Data in the DocTools tab. The DocTools tab may also contain tools from other add-ins provided by DocTools.

The result of extracting acronyms, tracked changes and comments are slightly improved versions of the results you get by using the free macros available on this website. The functionality for extracting bookmarks is available in the add-in only.

How to get the DocTools ExtractData add-in for free

Click the link below to learn more about DocTools ExtractData. You can download the add-in for free.

BulletGo to the DocTools ExtractData add-in on wordaddins.com

Add-in for generating list of acronyms and abbreviations, incl. definitions

The functionality for extracting acronyms included in the DocTools ExtractData add-in finds and extracts acronyms consisting of 3 or more letters. It does not extract any definitions. If you are working with large documents with many abbreviations and acronyms you should have a look at the Acronyms Master add-in. I was actually working on an advanced add-in for extracting acronyms including their definitions when I found Acronyms Master developed by Alexander Becker. After having tested Acronyms Master I decided to refer to that add-in instead - it is easy to use, affordable and includes all the functionality you need.

You can try out Acronyms Master for free.


Acronyms Master



Top of page

Macro solution

Read below if you want to use the macro instead of the add-in:

About the comments document that is created

The document with the extracted comments will include a header with the following information:

BulletFull name of the document from which the comments were extracted
BulletName of the document creator
BulletCreation date

The comments and metadata will be filled into a 5-column table. For each comment, the table will show:

BulletPage number
BulletThe text that was commented (i.e. the scope)
BulletThe comment itself
BulletName of the author who inserted the comment
BulletDate when the comment was added, date format dd-MMM-yyyy

See the illustration below.

Example of comments extracted to a new document

Note that you may need to change the table layout. Among other factors, the result will depend on your default table settings.



Related information

See general information about VBA macros and code snippets, incl. information about how to install macros.


For a macro that can extract tracked changes from the active document, see "Extract tracked changes to new document".


Top of page

Back to Macros...




Copyright © 2006-2017 Lene Fredborg – DocTools ApS – alle rettigheder forbeholdt | Microsoft Word skabeloner (templates) – add-ins – VBA makroer | Spar tid og arbejd mere effektivt i Microsoft Word
Privat politik | Betingelser for brug | Om cookies | Bogmærk denne side | Tip en ven | Links | Kontakt