see if it helps *Excel to Powerpoint Macros * http://akoul.blogspot.com/2011/06/excel-to-powerpoint-1.html http://akoul.blogspot.com/2011/06/excel-to-powerpoint-2.html http://akoul.blogspot.com/2011/06/excel-to-powerpoint-3.html http://akoul.blogspot.com/2011/06/excel-to-powerpoint-4.html http://akoul.blogspot.com/2011/06/excel-to-powerpoint-5.html http://akoul.blogspot.com/2011/06/excel-to-powerpoint-6.html http://akoul.blogspot.com/2011/06/excel-to-powerpoint-7.html
On Fri, Aug 19, 2011 at 2:14 AM, Mike Miller <mike.a.mil...@gmail.com>wrote: > Here is the loop that we are using to paste chart object into > Powerpoint > > 'Loop through each chart in the Excel worksheet and paste them into > the PowerPoint > For Each cht In ActiveSheet.ChartObjects > > 'Add a new slide where we will paste the chart > newPowerPoint.ActivePresentation.Slides.Add > newPowerPoint.ActivePresentation.Slides.Count + 1, ppLayoutText > newPowerPoint.ActiveWindow.View.GotoSlide > newPowerPoint.ActivePresentation.Slides.Count > Set activeSlide = > > newPowerPoint.ActivePresentation.Slides(newPowerPoint.ActivePresentation.Slides.Count) > > 'Copy the chart and paste it into the PowerPoint as a Metafile > Picture > cht.Select > ActiveChart.ChartArea.Copy > activeSlide.Shapes.Paste.Select > > > The issue is that the chart is loosing its formatting (colors etc) - > how do we retain this when pasting? > > Mike > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com <http://akoul.blogspot.com/> http://akoul.posterous.com/ *akoul*.wordpress.com <http://akoul.wordpress.com/> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> P Before printing, think about the environment. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel