View Single Post
  #2   Report Post  
Oliver Ferns via OfficeKB.com
 
Posts: n/a
Default

Here's how to copy a chart as a bitmap picture from Excel...

From Excel VBA Help:
CopyPicture method as it applies to the Chart object.

Copies the selected object to the Clipboard as a picture.

expression.CopyPicture(Appearance, Format, Size)

expression Required. An expression that returns one of the above objects.

Appearance Optional XlPictureAppearance. Specifies how the picture should
be copied.

XlPictureAppearance can be one of these XlPictureAppearance constants.
xlPrinter. The picture is copied as it will look when it's printed.
xlScreen default. The picture is copied to resemble its display on the
screen as closely as possible

Format Optional XlCopyPictureFormat. The format of the picture.

XlCopyPictureFormat can be one of these XlCopyPictureFormat constants.
xlBitmap
xlPicture default

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

....and here is how to pastespecial as a picture in Outlook:

......View.PasteSpecial DataType:=ppPasteOLEObject, _
DisplayAsIcon:=msoTrue, IconLabel:="New Bitmap Image"

Should do the trick but you havent stated whether you are working in Excel
VBA, Powerpoint VBA, or stand-alone VB6 App, so I can't offer any useful
code....

Hth,
Oli

--
Message posted via http://www.officekb.com