Thanks Ashish On Sep 14, 9:09 am, Ashish Jain <26may.1...@gmail.com> wrote: > > Hi Mohit, > > > Please visit - > >http://www.excelitems.com/2009/09/export-excel-2007-charts-to-powerpo... > > or check the VBA Code in attached file. > > > -------------------------------------------------------------------------- > > Thanks & Regards > > Ashish Jain > > (Excel Macros - Google Group Manager) > >http://www.excelitems.com > > (Developer of OpenXL) > >http://www.openexcel.com > > Excel,VBA,VSTO Trainer > > Ph. No. - 0x25402CF2B > > --------------------------------------------------------------------------- > > > On Sat, Sep 12, 2009 at 7:19 PM, Mohit Agarwal <mohit.i...@gmail.com>wrote: > > >> Hi Everyone, > > >> I am new to VBA and am not sure whether it is even possible to do it from > >> an Excel Macro. > > >> I am attaching an Excel Sheet and a powerpoint template. I have some > >> graphs in different worksheets. I want to export them to powerpoint as > >> Enhanced Metafile image. All the powerpoint slides have a pre-defined > >> constant structure and only the Graphs and text in red is to be changed > >> according to the information in excel. The graphs are always to be pasted > >> at > >> a fixed location on the slide. > > >> So is it possible to have a macro code that automatically exports all the > >> graphs as Enhanced Metafile images at the fixed location on PPT and changes > >> the text as well. Even if i can have a macro code that just pastes the > >> graph > >> at the fixed location without changing the text will do. I always have to > >> copy paste the graph and adjust its formatting. If it can be done it will > >> be > >> really great. > > >> Regards > >> Mohit Agarwal > >> 09214368691 > > >> "We are what we do repeatedly. Excellence then, is not an act, but a > >> habbit" - Aristotle > > > > Export_Excel_to_Powerpoint.xlsm > 30KViewDownload
--~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
