View Single Post
  #3   Report Post  
Jon Peltier
 
Posts: n/a
Default

Sandy -

Why paste it as a bitmap? If it is displayed at anything but the
resolution of the chart in Excel, it will look horrible. You will have
better results pasting it as a picture, which means metafile. This will
not suffer from distortion if it has to be resized. Even better if you
copy it in Excel as a picture, by holding Shift while clicking on the
Edit menu. Copy becomes Copy Picture. Use the On Screen and As Picture
options.

For more info:

http://peltiertech.com/Excel/XL_PPT.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Sandy wrote:

I am trying to copy an Excel graph to PowerPoint as a Bitmap.

PowerPoint does not seem to support paste as bitmap via a macro. Excel does
not seem to support copying a graph as a bitmap (it does support coping
worksheet data as a bitmap using the syntax "Selection.CopyPicture xlScreen,
xlBitmap").

How can I copy a graph worksheet from Excel to PowerPoint via VB code?

Thank you.

Sandy