wdPasteDataType

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

wdPasteBitmapBitmap (4) This is degraded quality, very grainy
wdPasteDeviceIndependentBitmapDevice Independent Bitmap (5)
wdPasteEnhancedMetafileEnhanced Metafile (9) (with resizing after works) To match Excel size
Best for not linked Excel ranges
wdPasteHTMLHTML (10)
wdPasteHyperlinkHyperlink (7)
wdPasteMetafilePictureMetafile Picture (3) Doesn't work with Selection.CopyPicture - must be Selection.Copy
wdPasteOLEObjectOLE Object (0)
wdPasteRTFRich Text Format (1)
wdPasteShapeShape (8)
wdPasteTextText (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

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top