 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / November 2004CopyPicture Colors to PowerPoint
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/ _______ > Hi > [quoted text clipped - 20 lines] > TIA > Ben |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.