View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mark Ivey[_2_] Mark Ivey[_2_] is offline
external usenet poster
 
Posts: 171
Default 2007 Excel / Powerpoint copy paste problem

I had a very similar problem recently and had to resort to using screen
shots...

I would be interested if there is actually a fix for this one...

Mark

wrote in message
...
We have an excel application that uses CopyPicture on an Excel
worksheet that has text and bar graphs, then instantiates a Powerpoint
object and pastes into a slide. In versions prior to 2007, this works
fine. But in Excel 2007, the paste displays correctly, but when
printed, only the bar graphs are printed. The CopyPicture uses
Type:=xlScreen, Format:=xlBitmap. When I manually pastespecial into
Powerpoint, I am prompted for type; I choose Bitmap and the print-out
looks fine.

Can anyone shed light on this ?

Thanks,
Phil