Hey guys,



Was just wondering if there was a neat way to take data entered into a word document and extract it into excel or something similar? The data I want would all be from text fields/checkboxes/date pickers and such.

Hi,
Yes you can do this.

Firstly you need to export the completed form as a TXT file but first you need to go into File > Options. Select the Advanced section and scroll down till you see the Preserve Fidelity when sharing this document section. Tick the box for Save form data as delimited text file then click OK.

Open a copy of the completed form in Word. Select Save As and choose the file format as .txt. Now open Excel and select the Data tab and click the From Text button within the Get External Data group. Locate the TXT file you just saved, click Import, go through the Text Import Wizard and select Delimited as the file type, select the comma option as the delimiter you are using and complete the wizard and the data will be bought straight into Excel. You just repeat for each completed form.

Once you are finished the process and no longer need forms to save the data only I'd untick the option in the File > Options in Word.

There may be a slight difference in the sequence in Word 2013 but the option is certainly available as I'm using 2010 at present.

If you have multiple documents to process, it's probably best to do the data extraction from Excel. For a macro to do this with content controls, see:
http://www.vbaexpress.com/forum/show...l=1#post257696
and, for modifications to that code for working with formfields, see:
http://www.vbaexpress.com/forum/show...l=1#post291047

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]