CopyPicture Colors to PowerPoint

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

Hi

I am trying to automate the copying of charts from Excel 97 to a PowerPoint
97 slideshow. On some machines, the colours do not get copied across
correctly. I have tried various combinations of the parameters for
CopyPicture, but none seem to get around the problem.

Does the colour palette have to be copied across also? If so, how is it
achieved?

This is a snippet of my code...

Set nextChart = nextWorksheet.ChartObjects(1).chart
Call nextChart.CopyPicture(xlScreen, xlPicture, xlScreen)
Set ppSlide = ppPresentation.Slides.Add(newSlidePosition,
ppLayoutBlank)
Set nextShapeRange = ppSlide.Shapes.Paste


Versions:
Excel 97 SR-2
PowerPoint 97 SR-2

TIA
Ben
 
Ben -

I've been copying pictures of Excel charts to PowerPoint for years, and I don't
recall colors being distorted by the process.

Did you ask also in the PowerPoint group? They have a couple guys who are very good
at Excel-PowerPoint interactions, and being PowerPoint guys, they know more about
how PowerPoint handles colors.

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