Thread: Input data into Word through Excel

Hi, people.
I need to open a Word file in Excel and then input data into some fields using values in the Excel cells. Do I have to use VBA?
How can I do this? Initially how do I open a Word File?
Thanks.

To do it automatically you will need to use VBA, to open a word document you can adapt this:

Code:

Dim MyDoc As Object
Set MyDoc = GetObject("D:/msword/directory/document.doc")
MyDoc.Application.Visible = True
MyDoc.Parent.Documents.Open FileName:="D:/msword/directory/document.doc"