Exporting multiple data sets from a single Word Form into Excel

[Tom Saylor]

PROBLEM: I have a multi-page MS Word file, each page of which contains a single discrete data set, with each datum entered as a content control. [In this case, each data set comprises a question and five multiple-choice answers, along with some classifications.] I want to export the data from this Word file into an Excel sheet so that each data set appears in a separate row in the spreadsheet.

Is there a macro available that will allow me to make this transfer?



I’ve found a macro created by Paul Edstein to export data from multiple Word files, each containing a single data set, but I need a macro that allows me to export data from a single Word file containing multiple data sets.