Excel VBA Connecting with Powerpoint Application

Excel VBA Connecting with Powerpoint Application

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

Interacting with PowerPoint Application and making presentation on Auto mode

Url: View Details

What you will 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.

Rating: 4.35

Level: Expert Level

Duration: 6 hours

Instructor: ajay parmar