Thread: Excel 2010 VBA to PowerPoint
2014-07-30, 10:43 #1
- 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.
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!
+ 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!
2014-07-30, 11:49 #2
- Join Date
- Aug 2010
- Pa, USA
- Thanked 227 Times in 210 Posts
you might want to add the reference to the Microsoft Power Point 14.0 Object library
Last edited by Maudibe; 2014-07-30 at 11:53.