Entering data from Word into Excel

[blindzero678]

Hello,

I am trying to create a form in Word 2007. This form would have several text boxes, dates, check boxes, and drop down menus. The form would then be sent to clients to be filled out and returned to me.

What I would like to do is have two command buttons at the bottom of the form. The first would check to make sure the form was completely filled out and then save the form. The second (which the client would not be able to see and/or click) would allow me to enter the data into a pre-existing excel spreadsheet.

Is there any way to do this? Right now I am stuck trying to figure out how to get vba to write to a specific excel file. Any help at all would be greatly appreciated!

Thank you!