Hi Alok,
Thank you. Regards Hari kumar _____ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Alokeshwar Tiwary Sent: Tuesday, March 10, 2009 6:35 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: charts to powerpoint Dear Hari, Attached zip file contains tow example files for your problem. Unzip both files in same folder and then open Power Point file and run macro xlchartpastespecial macro. The macro will copy all charts from excel file to power point. You may record a macro to change chart position in the slide. Or you can modify below code to change the position of the chart: ActiveWindow.Selection.SlideRange.Shapes("Picture 1").Select With ActiveWindow.Selection.ShapeRange .IncrementLeft 308.25 .IncrementTop 180.75 End With ____________________________________________________________________________ _____________________ "There are known knowns. These are things we know that we know. There are known unknowns. That is to say, there are things that we know we don't know. But there are also unknown unknowns. There are things we don't know we don't know." _____ From: hari <prekkeh...@gmail.com> To: excel-macros@googlegroups.com Sent: Wednesday, 11 March, 2009 11:29:52 AM Subject: $$Excel-Macros$$ charts to powerpoint Hi All, I have a problem of inserting 6 charts from a excel sheet to slide in power point. The effort is doing for almost 58-60 slides in a similar fashion. I got the code for getting the charts into a power point slide. Can anyone advise me with formatting the positioning of the charts in power point thru vba code excel. Regards Hari kumar _____ Add more friends to your messenger and enjoy! Invite <http://in.rd.yahoo.com/tagline_messenger_6/*http:/messenger.yahoo.com/invit e/> them now. --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
