Edit

Shapes.PasteSpecial method (PowerPoint)

  • Article

Pastes the contents of the Clipboard, using a special format.

Syntax

expression.PasteSpecial (DataType, DisplayAsIcon, IconFileName, IconIndex, IconLabel, Link)

expression A variable that represents a Shapes object.

Parameters

Name Required/Optional Data type Description
DataType Optional PpPasteDataType A format for the Clipboard contents when they're inserted into the document. The default value varies, depending on the contents in the Clipboard. An error occurs if the specified data type in the DataType argument is not supported by the clipboard contents.
DisplayAsIcon Optional MsoTriState MsoTrue to display the embedded object (or link) as an icon.
IconFileName Optional String If DisplayAsIcon is set to msoTrue, this argument is the path and file name for the file in which the icon to be displayed is stored. If DisplayAsIcon is set to msoFalse, this argument is ignored.
IconIndex Optional Long If DisplayAsIcon is set to msoTrue, this argument is a number that corresponds to the icon you want to use in the program file specified by IconFilename. For example, 0 (zero) corresponds to the first icon, and 1 corresponds to the second icon. If this argument is omitted, the first (default) icon is used. If DisplayAsIcon is set to msoFalse, then this argument is ignored. If IconIndex is outside the valid range, then the default icon (index 0) is used.
IconLabel Optional String If DisplayAsIcon is set to msoTrue, this argument is the text that appears below the icon. If this label is missing, Microsoft PowerPoint generates an icon label based on the Clipboard contents. If DisplayAsIcon is set to msoFalse, then this argument is ignored.
Link Optional MsoTriState Determines whether to create a link to the source file of the Clipboard contents. An error occurs if the Clipboard contents don't support a link.

Return value

ShapeRange

Remarks

Adds the shape to the collection of shapes in the specified format. If the specified data type is a text data type, a new text box is created with the text. If the paste succeeds, the PasteSpecial method returns a ShapeRange object representing the shape range that was pasted.

The DataType parameter value can be one of these PpPasteDataType constants:

  • ppPasteBitmap
  • ppPasteDefault
  • ppPasteEnhancedMetafile
  • ppPasteHTML
  • ppPasteGIF
  • ppPasteJPG
  • ppPasteMetafilePicture
  • ppPastePNG
  • ppPasteShape

The DisplayAsIcon parameter value can be one of these MsoTriState constants.

Constant Description
msoFalse The default. Does not display the embedded object (or link) as an icon.
msoTrue Displays the embedded object (or link) as an icon.

An error occurs if there is no data on the Clipboard when the PasteSpecial method is called.

If the source content is not fully downloaded, this method fails and an error occurs. For more information about the Partial Documents, see Work with Partial Documents.

See also

Shapes Object

Work with Partial Documents

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.