gnome88
Thu Jul 28 05:24:01 CDT 2005
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.
"Doug Robbins" wrote:
> 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" <gnome88@discussions.microsoft.com> wrote in message
> news:BCE554C4-967B-468D-88E0-52EFED242BF8@microsoft.com...
> > 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?
> >
> >
>
>
>