Word form data to Excel?

[Sandy]

I am trying to dump the data in Word form fields into an
Excel spreadsheet. I can't find a way to do this from
either Word 2002 or Excel 2002.

Basically, I am receiving completed Word forms from
multiple people, and I'd like to keep everyone's
information in one spreadsheet. I can cut and paste if
necessary, but I was hoping for a more automated option.

Is this possible?
Thanks,
Sandy

 

[Cindy Meister -WordMVP-]

Hi Sandy,

I am trying to dump the data in Word form fields into an
Excel spreadsheet. I can't find a way to do this from
either Word 2002 or Excel 2002.

I wrote an article about this kind of thing a couple of
years ago. Unfortunately, it's no longer available on-line;
it can be purchased on a CD (together with lots of other
good developer articles) at
https://www.mssmartsolutions.com/Orders/cdorders.asp

Basically, you have two possible approaches:
1) The documents can be set in Tools/OPtions/Save to save
data only. this will generate a delimited text file that
can be imported, via the DATA menu, directly into Excel.
Technically, no VBA would be required (althoug it would
certainly help speed things up!)

2) VBA could be used to extract the data and write it into
Excel. You should find sample code how to automate
Word/Excel from the other application. Then all you'd need
to add to that is how to get the data specifically from a
form field. For a text form field:
ActiveDocument.Formfields("TheName").Result

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jan 24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail