Library

Course: Excel VBA Connecting PowerPoint Application - Series 9

Excel VBA Connecting PowerPoint Application - Series 9

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
About this Course
  • Discussing about the connectivity of excel with power=point in this advance series using Excel VBA.
  • Taking a deep dive into power-point classes like Presentation class, Slide class and shapes class. Understanding the power-point object hierarchy.
  • Real time projects discussion with you to give you live exposure of working with Power-point.
  • Understanding the concept of Early Binding and Late Binding methods or techniques
  • Live Projects for you - Fully automated and high level automation.
  • This course will have my email support as well.


Basic knowledge
  • Good knowledge of Loops and Collection loops along with understanding of Charts is must
  • This is super advance series where we are going to connect power-point with Excel so you need to have good understanding of Loops and basic knowledge of classes
What you will learn
  • You will be able to understand the power-point object hierarchy and its classes which will be useful in automating the daily PPT work for you
  • You will be able to understand the basic logic behind connecting excel with other applications , In this case it is power-point
  • You will be able to understand the power-point object hierarchy and its classes which will be useful in automating the daily PPT work for you
Curriculum
Number of Lectures: 8
Total Duration: 04:31:07
PowerPoint Connectivity
  • Chapter 1  
    • This is our first session on PowerPoint application. We are learning about PowerPoint objects ,their hierarchy and what they do .
    • How we use these Classes in Excel VBA
    • What is the theory behind connection excel with other applications like in this case it is PowerPoint.


  • Chapter2  

    We are learning to copy charts from every sheet of a workbook and pasting them in powerpoint to make a presentation in seconds with the help of this code. Using worksheet collection loops to automate this great project.

  • Chapter3  

    If you like to deal with existing power-point and not the new one and in this already created power-point we have to paste some charts but in the new slides of it then how we can do it. It means , how we can leave the existing slides untouched and start pasting charts in new slide which will be just after the last slide , the existing one. 

  • Chapter4  
    • We must learn how to have good control over slides and shapes which we use when we work with presentations. Here we are discussing about collections loops.
    • How to Loop over slides one by one in powerpoint presentation
    • How to loop over shapes pasted inside each slide 


  • Chapter5  
    1. This is a project i got it from one of my students. Its one hour project which i am sharing it with you, This project will give you lot of exposure in terms of handling the powerpoint object classes and other things like collection loops and input boxes. Here we are going in specific slide and deleting the wanted shape and pasting our own selected range. Very powerful and unique project in its own. Watch it when you have full one hour.
    2. One has to be good in collection loops . Charts and Worksheet collection loops



  • Chapter6  

    In this video we are learning how to add shapes or pictures in every slide but with a condition that each slide will have four pictures pasted, So, if you have 12 images or shapes or pictures , your vba code will create three slides and each of it will have 4 shapes getting pasted.

  • Chapter7  

    This is one of my greatest project which is covering everything about Powerpoint and Excel VBA. See this from scratch.

    To practice on this download the code file and then create your own dummy other excel file from where we need to pick ranges and charts as shown in the video and then start doing it.

  • chapter8  

    Its a surprise test for you. Let us see how much you score in it. Please understand the questions first and then do it without looking at the solutions. later, of-course you can come back and see the coding. All the best. This is not just a test but also a good revision

Reviews (0)