Select and Copy from Word to Excel

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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