wdPasteDataType

Specifies the format for the Clipboard contents when they are inserted into a document.

wdPasteBitmap	Bitmap (4) This is degraded quality, very grainy
wdPasteDeviceIndependentBitmap	Device Independent Bitmap (5)
wdPasteEnhancedMetafile	Enhanced Metafile (9) (with resizing after works) To match Excel size Best for not linked Excel ranges
wdPasteHTML	HTML (10)
wdPasteHyperlink	Hyperlink (7)
wdPasteMetafilePicture	Metafile Picture (3) Doesn't work with Selection.CopyPicture - must be Selection.Copy
wdPasteOLEObject	OLE Object (0)
wdPasteRTF	Rich Text Format (1)
wdPasteShape	Shape (8)
wdPasteText	Text (2)

wdPasteBitmap

Bitmap (4) This is degraded quality, very grainy

wdPasteDeviceIndependentBitmap

Device Independent Bitmap (5)

wdPasteEnhancedMetafile

Enhanced Metafile (9) (with resizing after works) To match Excel size
Best for not linked Excel ranges

wdPasteHTML

HTML (10)

wdPasteHyperlink

Hyperlink (7)

wdPasteMetafilePicture

Metafile Picture (3) Doesn't work with Selection.CopyPicture - must be Selection.Copy

wdPasteOLEObject

OLE Object (0)

wdPasteRTF

Rich Text Format (1)

wdPasteShape

Shape (8)

wdPasteText

Text (2)

REMARKS

* wdPasteEnhancedMetafile - there is no Linked option
* wdPasteOLEObject - with a range or chart, another workbook is created and added to the Word document
* wdPasteMetafilePicture - always distorts text when pasted into Word - is there a size where it works ??
* For more details refer to Tables > Pasting From Excel