Macro to copypaste data from Excel to Word

[Trilliput]

Hi,

If anyone could help me with the following, I'd be very grateful:

There is a sheet with data which I'd like to copypaste into a Word file. Specifically, I want to insert the values from one row into one text box. In the Word document, there should be up to 8 text boxes per page, the text boxes being of a specific format.

I have found this solution for switching between Excel and Word, but I have no idea how to tell Word to "put it into this box and make the next one".

Sub Macro1()

Dim oWrd As Object
Set oWrd = CreateObject("Word.Application")
oWrd.Visible = True
oWrd.documents.Add
oWrd.Application.Run MacroName:="Macro1"
oWrd.ActiveDocument.SaveAs Filename:="Hi ther1.doc"
oWrd.Application.Quit
MsgBox "now back to Excel"
​

End Sub

Any assistance is much appreciated!

Thanks,

T.