copy word form field contents into excel spreadsheet

[gnome88]

Can someone help me with the code to open a word document that is a survey
form with 6 form fields. I want to open the document, copy the contents of
the form fields (name_txt, email_txt, check1_checkbox, etc) to my excel
spreadsheet.

I am having my college math students complete a word-form document and want
to capture all of the responses into a single worksheet with a row for each
students information.

Thanks,

Dave
Was this post helpful to you?

 

[Doug Robbins]

Here's a couple of articles that contain some information that should help
you:

"Find & ReplaceAll on a batch of documents in the same folder" at:

http://word.mvps.org/FAQs/MacrosVBA/BatchFR.htm

"Control Excel from Word" at:

http://word.mvps.org/FAQs/InterDev/ControlXLFromWord.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[gnome88]

Doug,

Thank you for pointing me towards a resource of information that I missed.
The first reference didn't help. The second provided an idea of code I might
try where I reverse the order of control (excel control over word). I found
another potential solution and am currently working to make it work; have the
word form document saved as 'form data' only, then import the .txt file into
excel. I am working on (looking for) code that allows me have a word
document in 'protected form' and allows a macro to fire on closure that would
set the tools/option/save as form data only and ask the user for a file name.
This file would be emailed back to me and I would then use my excel program
with appropriate macros to load the data.

Any ideas?

Thanks for your feedback.