Expand Minimize

Range.PasteExcelTable Method (Word)

Pastes and formats a Microsoft Excel table.

expression .PasteExcelTable(LinkedToExcel, WordFormatting, RTF)

expression Required. A variable that represents a Range object.

Parameters

Name

Required/Optional

Data Type

Description

LinkedToExcel

Required

Boolean

True links the pasted table to the original Excel file so that changes made to the Excel file are reflected in Microsoft Word.

WordFormatting

Required

Boolean

True formats the table using the formatting in the Word document. False formats the table according to the original Excel file.

RTF

Required

Boolean

True pastes the Excel table using Rich Text Format (RTF). False pastes the Excel table as HTML.

This example pastes an Excel table into the active document. The parameters specify that the pasted table is linked to the Excel file, retains the original Excel formatting, and is pasted as RTF. This example assumes that the Clipboard contains an Excel table.

Sub PasteExcelFormatted() 
 Selection.PasteExcelTable _ 
 LinkedToExcel:=True, _ 
 WordFormatting:=False, _ 
 RTF:=True 
End Sub

Concepts

Other resources

Show:
© 2014 Microsoft