Chart.CopyPicture (Excel)

Copies the selected object to the Clipboard as a picture.

CopyPicture (Appearance, Format, Size)

ActiveChart.CopyPicture

Arguments

Optional arguments

The following arguments are optional

Appearance (XlPictureAppearance) - Specifies how the picture should be copied. The default value is xlScreen.

Possible return values are xlPrinter - The picture is copied as it will look when it is printed, xlScreen - The picture is copied to resemble its display on the screen as closely as possible.

Format (XlCopyPictureFormat) - The format of the picture. The default value is xlPicture.

Possible return values are xlBitmap - Picture copied in bitmap (raster) format: bmp, jpg, gif, png, xlPicture - Picture copied in vector format: emf, wmf.

Size (XlPictureAppearance) - The size of the copied picture when the object is a chart on a chart sheet (not embedded on a worksheet). The default value is xlPrinter.

Possible return values are xlPrinter - The picture is copied as it will look when it is printed, xlScreen - The picture is copied to resemble its display on the screen as closely as possible.