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

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

<(E-Mail Removed)> wrote in message
news:e6c9f6b4-365a-48eb-b359-(E-Mail Removed)...
> 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