Hi Bob,

Since you don't detail what you've tried, it's a bit
difficult to say much more than, "Yes, it's possible and yes,
you need to use VBA."

Assuming the users have returned the full form (and not used
"Save data only" and sent that back), my preference would
probably be to have the VBA code
   - open each form in succession (from the same folder)
   - loop through the form fields and pass the data to where
I want to save it

If this were a "real" database, I'd probably use ADO, create
a set of records, then send an UPDATE command through the
connection to the table.

For Excel, I can see three possible approaches
   - write each field to the appropriate cell; moving to a
new line for each new record (I think this must be what you
tried, and the point you missed)

   - writing to a text file, in delimited format, and
importaing that to Excel

   - setting up an ADO dataset and using Excel's internal
CopyFromRecordset method to drop it into the worksheet

In any case, you should follow up on this in an appropriate
programming newsgroup (excel.programming for the Excel parts;
a Word.vba group for the Word parts).

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 :-)