Hi ?B?Si5Qb2xheWVz?=,

After creating a form in word using various field types, need to know how to
gather that data automatically into an Excel spreadsheet?

"field types" as in form fields from the Forms toolbar? Or something else?
Version of Word?

There is no functionality that will automatically transfer data in a Word
document to Excel. A document with form fields can be set to save ONLY the data
entered into the form fields (see Tools/Options/Save). This creates a
comma-delimited text file, which can then be imported into an Excel spreadsheet
(one-by-one). This is the only possibility that doesn't involve programming
(macros).

Getting into the realm of macro programming, you could have a macro in Excel
that would import, say, all the csv files in a folder, so that you wouldn't
have to do it one at a time.

You could also have a macro in Word that would read the information directly
from the form fields and write it to an Excel file. I think there are a couple
of tutorials on automating Excel from Word (or Word from Excel) that might give
you start on this at word.mvps.org.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

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