Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel VBA Connecting with Powerpoint Application
Rating: 4.0 out of 5(25 ratings)
231 students
Created byajay parmar
Last updated 1/2023
English

What you'll learn

  • You will be able to understand the basic logics behind connecting excel with other applications , In this case it is powerpoint.
  • 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.
  • How to use PowerPoint library before running a code.
  • How to create PowerPoint applications and make them visible.
  • How to create slides and give them indexing one by one. What precautions need to be taken care .
  • Learn the powerpoint application classes like Slides, Presentation, Shapes. How to use them in proper hierarchy way
  • How to paste Charts and Range objects from Excel to Powerpoint slides.
  • How to resize the chart size once it is pasted on Slides. How to move the pasted charts in a slide
  • How to delete or move charts from one slide to another.
  • How to paste all charts in one slide only OR Paste one chart in one slide.
  • How to delete the slides if needed and how to start working with nth slide , if needed.
  • How to work with already existing Powerpoint application instead creating a new one.
  • How to avoid existing PPT Slides and paste data in new slides but within the same existed PPT.
  • What happens when you share code with others who are using different version of PowerPoint.
  • I have shared several very amazing and powerful projects with you as well to give you real results if you are serious about business.
  • Know your Early binding and Late binding approach - So amazing and must know thing for developers

Course content

1 section • 12 lectures • 6h 31m total length

  • A quick glance at course8:05
  • Let us understand the PowerPoint Classes first. - its fundamentals1:12:42

    • This is our first session on PowerPoint application. We are learning about PowerPoint objects ,their hierarchy and what these classes do in VBA .

    • How do we declare and  use these classes in Excel VBA

    • What is the theory behind connection excel with other applications like in this case it is PowerPoint. Why we need to activate the PowerPoint library in VBA Editor.

  • Paste Charts in newly created PowerPoint Slides - Let us begin the real journey24:46

    • Let us create a new PowerPoint application and start working on it.

    • We are now learning as to how 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.

    • What if we have to paste every chart from each and every sheet in excel. Learn how to use worksheet collection loops to automate this great project.

  • How to work with Existing PowerPoint presentations - We need to be All-Rounder24:10

    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. 

  • Control your Slides and Shapes with Collection Loops - Simply amazing52:31
    • 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 
  • Powerpoint Wonderful Project for you59:21

    • 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.

    • Please Watch it when you have full one hour.


  • Powerpoint one More Project for you - its a serious learning32:24

    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.

  • Powerpoint (Personal) Project - Simply awesome1:01:23

    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.

  • Early Binding and Late Binding Discussion In general15:47

    in general - we are discussing the late binding and early binding . Which one is better and why one should use which binding. Talking about the scenarios when you like to connect excel with ms word or powerpoint or outlook.

  • Surprise Test for you - 3 Questions16:28

    Its a surprise test for you. Let us see how much you score in it. Pls 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

  • My Courses with links and Coupon Codes - 30 + Series waiting for you2:10

    If you like to learn  more on advance excel or excel vba or PowerQuery, m code, webscraping VBA or ms access, ms access VBA or Powerpivot , DAX, PowerBI , these links will help you a lot.

    For any questions or doubts, please reach out to me at ajayk3802@gmail.com

  • How to insert Slides after every 5th existing Slide till last one -Your question21:18

Requirements

  • Knowledge of Loops and Collection loops along with understanding of Charts is must.
  • This is super advance series where we are going to connect powerpoint with Excel so you need to have good understanding of Loops and basic knowledge of classes.
  • If you do not know much about loops and Charts - You can still follow the tutorials and tweak the lines as and when needed in your project.

Description

  • Discussing about the connectivity of Excel with PowerPoint in this advance series using Excel VBA.

  • How to copy  table data from excel and paste into PowerPoint application slides.

  • How to export charts from excel sheets to PowerPoint and paste them in one slide or more slides one by one.

  • Taking a deep dive into power-point classes like Presentation class, Slide class and shapes class. Understanding the power-point object hierarchy.

  • How every class is responsible for other class using the dot hierarchy.

  • How to work with already created PowerPoint applications and also how to create new PowerPoint applications and work with them.

  • How to resize the charts or tables images in slides and move them to the top or left or right of the slides.

  • Control which chart should go in PowerPoint using the excel sheet cells.

  • How to loop through all sides and decide which one to be deleted or used for data presentation.

  • Collection loops for slides as well as shapes. This is amazing source of learning.

  • 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

  • Several highly advance level Projects for you - Fully automated and very very knowledgeable practical projects.

  • This course will have my email support as well.


Who this course is for:

  • Students who want to learn how to Connect Excel with PowerPoint application to make Presentations.
  • if you work on PPTs a lot and that needs to be automated using excel VBA then come and join me in this fabulous journey.

Report abuse