Excel VBA Connecting with Powerpoint Application

Interacting with PowerPoint Application and making presentation on Auto mode

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

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

• Connecting Powerpoint with Excel VBA –> 12 lectures • 6hr 31min.

Requirements

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