I have a userform on a Microsoft Word Document which has
17 textbox's on it, when the user fills in all the
textbox's and clicks the ok button (or submit as I have
called it), the pieces of text are then inserted into a
standard document in certain places which are marked
using bookmarks.

What I would like is to keep a database record of the
details that were submitted on the userform by the user.  
And then I want to be able to open the database in excel.

When the user clicks the submit button on the userform, I
want the details that the user has entered in the
textbox's to be added to a data file (the database),
perhaps using the 'Append' facility e.g.: 'Open database
For Append As #1', etc. etc.

What code can I use to do this and what code can I use to
open up the datafile in Excel?

Many thanks in advance for your help.

Mark

Take a look at http://www.computorcompanion.com/LPMArticle.asp?ID=136

Please post any response to the newsgroups for the benefit of others who may
also be following the thread.

Hope this helps,
Doug Robbins - Word MVP