Excel VBA Introduction Part 28.1 - Creating PowerPoint Presentations

By Andrew Gould

[abhifriends]

Hi Andrew, your tutorial video is fantastic. What like most about your video is the care that you  take to touch upon nuances of different approaches. Being a fairly proficient in VBA, I recommend this to anyone who is interested in learning VBA. Good job posting such good quality video freely on tube when many people are trying to make money out of low quality trainings. Hats off.

[GaryHutsonVBA]

Solid work Andrew. I attended a Advanced VBA course years ago, and they never showed you how to work with Powerpoint. This will be really helpful when preparing statistics for presentations. I can essentially automate the whole process. Great stuff

[HenriquePevidor]

Ths is probably one of the best tutorials that I found on youtube. You show several approaches to get the same result, which is very good. I helped me a lot, since I am a noob in excel VBA. Congratulations for the video you posted. Amazing!

[NaimaEchalhi]

You don't ever disappoint! Thank you Andrew 😊

[william-owaingorsuch-barry]

This tutorial is perfect!  Thank you very much.  As an amateur, It has enabled me to really take my projects to the next level.  It has really good explanations and auxiliary codes that gives viewers a comprehensive understanding of what they are doing.  It also combines a little bit of everything that you need to know in order to get started using Excel and PowerPoint VBA.  For example, how to set up a new ppt slide show from Excel, adding and editing slides & shapes in PowerPoint through Excel.  Compatibility issues between older and newer versions, early binding vs. late binding.  It's great.  I'm going to send it to my business partner.  Thanks again.

[JohnSmith-tddn]

Holy Cow Batman! I hope you are being paid boxes and boxes of money. You are awesome!! Best video tutorials I have ever seen. Keep up the great work!!!

[KashifAli-kxcw]

Hi Andrew, Just want to sincerely say thank you for this excellent and brilliant tutorial ! I'm a beginner with VBA and currently working on a project to automate movement of data from Excel to PP and this video has truly given me the knowledge and initial building blocks I'll need to complete the project.  I truly thank you for sharing your expert knowledge!  Also thank you for the excellent explanations along with showing how to write the code with the sequences you provided, your delivery in terms of speed and overall rapport with the audience is excellent as well - I was able to follow along with you perfectly - I wish I could have you as an instructor lol.  Overall, thank you very very much for this tutorial as it has been extremely helpful to me.Questions: I have successfully utilized your code (using Excel 2013 and PP 2013) for the primary lessons you have provided.  However, I was unsuccessful in utilizing the code to copy a chart over to Excel.  My challenge now is to modify the code you have provided to fit my needs ... 1. I have more than 1 set of Excel ranges that I need to copy and paste to a single slide.  Please kindly advise how to do that ? Your video only shows how to copy and paste 1 range of excel data to 1 PP slide.2. I was unsuccessful in copying a chart over to PP.  In the area in VB where it says "VBAProject (Book1)" (not sure what that is called) the "Chart1" is not showing up there ... Is that the reason why I am unable to copy my chart over to PP ?Thank you once again for this brilliant tutorial - it is truly appreciated !

[Babbu]

just wanna say, Great work, you are awesome with ur skills... Thank YOU

[bredmond]

I love your videos. I have been watching them daily for the last few weeks, and also for a while a couple of months ago. I skipped this one after watching half of it because it just felt like it was about formatting and compatibility. But i guess that is really all that power point is anyway? I'm ready for Outlook!

[FM-zffz]

Wonderful Tutorial! From Beginner to Hero! Challenging bit was the later versions 2019 and others

[KayYesYouTuber]

Hello Andrew, If I do the following set then it works like a charm all the time:. I put in couple of Sleep functions after copying and before pasting.

ppSlide.Select

Sleep (50)
ppSlide.Select
Sleep (50)

ppSlide.Shapes.Paste.Select

[arliefrederick]

Andrew Great Video, I did have issues with the pasting but NBAH NBAHOB below gave code ppApp.Window(1).View.Paste and it worked, this is an issue with 2010 users.  Great Job and great teaching.  Thank you

[rodzmali]

This is just an amazing tutorial. Thanks a lot for this one!!!

[divyal]

Hi Andrew! Another amazing video. Thank you so much!

[kumar-manoj]

Thanks a lot sir, I learnt too much there.

[adadmohamedcherif]

Thank you very much Andrew , it is very nice of you

[WolfVanWeen]

Absolutely excellent video. Thank you very much!

[ecarlosbc]

Man, this is Gold :D. Thank you so much

[fedoriv]

Hi there,
Thanks for an insightful upload.

I found that to get around the paste problem in 2010-version of PP we can use this:
ppApp.Windows(1).View.Paste
Works like a charm.

[nidhimehta]

I loved this video absolutely.. just broke my heart when i realised at a later point that i would not be able to use paste for powerpoint 2010.. nonetheless extremely helpful..