VBA & Macro Problems

Extract Original and Revised Text from Word Track Changes with a VBA Macro

Jason MillerJason Miller Nov 13, 2026 869 views

Question details

The user needs to bulk-extract the original and revised versions of text from student documents containing Word Track Changes and place each version into separate table columns.

Product
Microsoft Word
Device & OS
not provided
Scenario
A reviewer or teacher has many student documents with Track Changes and needs to compare the original and revised text in separate review columns.
Observed behavior
Track Changes stores both versions in revision marks, but Word has no built-in one-click command to export the original and revised text into separate table columns.
Before you start

Save a copy of the original .docx file and enable the Developer tab before opening the VBA editor. Close other Word documents so the macro runs only against the active test copy.

Solution 1Recommended

Run a Track Changes VBA Macro to Export Original and Revised Text to a Table

Use this when you have many student documents and need a repeatable automated way to place original and revised text into separate table columns.

The DocTools Track Changes macro compares tracked revisions and exports the result. It can be adapted from individual words to complete lines or sentences, which is usually more useful when reviewing student writing.

1
Open the VBA editor

In Microsoft Word, press Alt+F11 to open the Microsoft Visual Basic for Applications editor.

2
Insert a code module

Click Insert > Module in the VBA editor menu to create a new standard module.

3
Paste and adapt the macro

Paste the Track Changes export macro from the DocTools site into the module, and change the extraction range from individual words to complete lines or sentences if the review requires full-sentence extraction.

4
Run the macro on a copy

Return to the Word document, press Alt+F8, select the macro name, and click Run. The macro should create or update a table with original text in one column and revised text in another.

Test before batch processing: Always run this macro on a small set of document copies first. Some revisions may be reordered or merged depending on how the macro reads deleted and inserted runs.
Free Microsoft Office alternative

Use WPS Writer as a Free Track Changes Review Alternative

When you do not need a specialized Word VBA export macro, WPS Writer offers a free, lightweight way to open .docx files with Track Changes, review revisions, and run the manual Accept/Reject extraction workflow.

Free to download and use for core Writer review tasksOpens and saves .docx files while keeping tracked changes and comments intactFamiliar Review tab with Accept, Reject, Previous, and Next reduces the learning curve when switching from Microsoft WordSupports the manual Accept/Reject workflow described in this articleLightweight installation that runs smoothly on everyday computers
microsoft office alternative - wps office

Frequently Asked Questions

Can I extract complete sentences instead of individual words with the DocTools macro?

Yes. Modify the VBA extraction range from word to a sentence or paragraph range, and test on a copy because changing the range can affect how deleted and inserted runs are grouped.

Does this macro work in WPS Writer?

WPS Writer can open tracked .docx files and use Accept/Reject commands, but complex Word VBA macros may require Microsoft Word. Run the extraction macro in Word for full compatibility, or use the manual method in WPS Writer.

Is there a built-in Word command to export original and revised text?

No. Word does not include a one-click command to export original and revised text into table columns. You need a VBA macro or the manual Accept All/Reject All approach.

Why should I run the macro on a document copy?

Macros that process tracked revisions can alter the revision history or merge changes. Using a copy preserves the original document and lets you repeat the process if the output is not correct.

Can I write the extracted text into an existing table?

Yes. The macro can be adapted to write to a new or existing table in specified columns, or you can manually copy the original and revised text into a two-column table.