Microsoft Office Forums - View Single Post

d4okeefe · 06-13-2018, 07:33 AM

You can create an Excel workbook within Word. First, add a Reference to Excel in Word VBA (Tools -> References -> Microsoft Excel 16.0 Object Library). Then you can run the following.

Code:

Sub createExcelWkbk()
    Dim obj As Excel.Application
    Set obj = New Excel.Application
    obj.Visible = True
    
    Dim wkbk As Excel.Workbook
    Set wkbk = obj.Workbooks.Add
End Sub

From here, you can use a range object in Word to add data to the Workbook.