link user form to Word document

[newprogamer]

Hello Everyone,

I have created a VBA user form that has a command button. When this command button is clicked, it should open a form in Word that will be a summary sheet for the data entered on the form. The data on the form has been linked to cells in excel.

How do I open the Word document?
How do I link the excel cell (or combo box) data to the Word document?

Any help or advice on a good source would be greatly appreciated.

Thanks,
New Programmer

 

[fumei]

You must create an instance of Word. See Help on CreateObject.

If the Word document exists, then use Documents.Open filename to open it.

If the Word document is using Form Fields to hold the information, then pass the information to the .Result property of the form field.

Hard to much else without knowing how you arestructuring the Word document.

Gerry