Word form data to excel

[Rua]

Hi,

I am very new to VBA and I would like to carry out the following
tasks:

I have created a word form, it is to be returned by up to 800 users.
Is it possible to automatically (via vba or macro) to extract the data
to either a single csv or to multiple csv's and then import them into
a single excel spreadsheet?

If anyone has done something similar I would be very interested.

Thanks in advance

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Hi Rua,

There is an option to save data only for forms. Alternatively, use
information from the following articles, you could create a batch process
that opened each form document, exctracted the information from the
formfields by referencing the .Result of each formfield and write it into an
Excel spreadsheet.

"How to Find & ReplaceAll on a Batch of Documents in the Same Folder" at:

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

"Control Excel from Word" at:

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

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP