Export MS Word Form Data to MS Excel

[NWHanover]

Hello,

I am trying to create a form in MS Word that a prospective member can fill out and return and the corresponding data fields can then be deposited in an MS Excel sheet. I am using a mix of ActiveX Controls (Text Box and Check Box) as my form fields. I have done some browsing for solutions and found a couple of VBA suggestions but they don't seem to work with ActiveX Controls.

Please let me know of any recommendations on how to get data from my MS Word form using ActiveX Controls to a MS Excel sheet - using VBA or other methods.

Thanks!

 

[Macropod]

Using ActiveX Controls is a bad idea if any of the users have Macs. ActiveX Controls have never been supported on Macs and do not work there. Is there a reason for not using formfields or content controls?

 

[NWHanover]

Macropod,

Thanks for replying to my OP. No specific reason for using ActiveX Controls aside from aesthetics and appearance - the text boxes seem more professional looking. I have had trouble getting form fields and content controls to do what I want (namely limit character length) but I would not count them out entirely if you believe compatibility issues would cause problems down the road. I would also need to use a drop-down list for a couple of fields but I'm not sure how that would affect the rest of the scenario.

Either way, let's say I re-design the form to use either form fields or content controls (including text boxes, check boxes, and drop down lists), do you know a good VBA solution to pull data from these fields into an Excel spreadsheet?

Thanks!

 

[Macropod]

I have had trouble getting form fields and content controls to do what I want (namely limit character length)

Formfields are supported in all Word versions on PCs and Macs. Content controls are only supported in Word 2007 & later for PCs and Word 2013 & later for Macs. You should not use formfields and content controls in the same document - they weren't designed to work together and using both can cause problems.

I would also need to use a drop-down list for a couple of fields but I'm not sure how that would affect the rest of the scenario.

Formfields and content controls both support dropdowns, so tha shouldn't be an issue.

Either way, let's say I re-design the form to use either form fields or content controls (including text boxes, check boxes, and drop down lists), do you know a good VBA solution to pull data from these fields into an Excel spreadsheet?

See: http://www.msofficeforums.com/word-vba/19914-how-transferring-word-data-excel-sheet.html#post59665
The Excel macro there will extract the formfield and/or content control data from all documents in the selected folder.