copy word form field contents into excel spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gnome88 - 27 Jul 2005 20:51 GMT

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?

Reply to this Message

Doug Robbins - 27 Jul 2005 22:03 GMT

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

Signature

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

> 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
[quoted text clipped - 12 lines]
> Dave
> Was this post helpful to you?

Reply to this Message

gnome88 - 28 Jul 2005 11:24 GMT

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.

> Here's a couple of articles that contain some information that should help
> you:
[quoted text clipped - 23 lines]
> > Dave
> > Was this post helpful to you?

Reply to this Message