Select and Copy from Word to Excel

d4okeefe · #1 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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel VBA - Select All in Word Doc & Update Fields	RMerckling	Excel Programming	1	04-27-2018 01:47 PM
Word 2007-cannot select or copy image	calvin-c	Word	2	01-05-2017 02:26 PM
How to select and copy to clipboard an entire document except for a paragraph and keep formatting	TD_123	Word VBA	7	06-16-2015 03:30 PM
Select Every Email in Word or Excel?!?	arielrivera67	Excel	2	07-13-2014 09:54 PM
how to copy all ms word tables into excel	rehan129	Word	0	01-28-2012 10:17 AM