Word Form Data Scraper

Word Form Data Scraper

I recently ran into the challenge of compiling the responses from hundreds of word forms at one of my jobs. The document had been set up with legacy text fields and wasn’t designed with moving data in mind. It was meant to be a simple survey that would be reviewed by a human at the end and individual decisions made based on the content. When I got there, the form had already been sent out and we were staring down hundreds of filled forms that needed to be made sense of an compiled into a sheet that could analyzed.

My solution was to scrape the data from the Word documents with a little bit of VBA, which is what I’m sharing today. If you find yourself in the same situation, this might make your life a little easier. You can download the Access File with the Word document scrape script and some Word form samples here and the video below features the script in action. Please feel free to use this however you wish!