Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Thanked 0 Times in 0 Posts

    Excel 2010 VBA to PowerPoint


    I am trying to create a powerpoint slide pack from Excel 2010 VBA.

    I have looked all the various suggestions and tried a number of different bits of code but I always "User Defined type not defined".

    All I am trying to do is open a template .ppt, then copy and paste a number of charts into each slide, maybe resize them.

    I know that Microsoft have removed the record function in powerpoint so I can play with the various options but just cannot get started.

    Any help appreciated.



  2. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    5 Star Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Pa, USA
    Thanked 228 Times in 211 Posts
    you might want to add the reference to the Microsoft Power Point 14.0 Object library

    Poperpoint Library.png
    Last edited by Maudibe; 2014-07-30 at 11:53.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts