How do I add Excel data to a word document

[Colex]

I create a document from a template that inputs (via a userform) various data. Within this data if a reference which relates to the row value of further data in a excel spreadsheet. How do I go about adding this data automatically to the document once the row value has been stated?

Thanks

[RobDog888]

Add a reference to Excel in your VBA IDE Project References.

Then open the workbook and read/write the cells/data you want.

Option Explicit

Private Sub Command1_Click()
Dim oApp As Excel.Application
Dim oWB As Excel.Workbook

Set oApp = New Excel.Application
Set oWB = oApp.Workbooks.Open("C:\Book1.xls")
MsgBox oWB.Cells(1, 1)

oWB.Close SaveChanges:=True
Set oWB = Nothing
oApp.Quit
Set oApp = Nothing
End Sub