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.
Subscribe to our Windows Secrets Newsletter - It's Free!
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 212 Times in 198 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.