Category Archives: Powerpoint

Excel data for PowerPoint

Accessing PowerPoint controls through Excel VBA

Creating a PowerPoint presentation using data from Excel is very common. You can simply create a new PowerPoint, copy all the data, and you’re done. But consider a periodic report — a sales report, for example. Each month you need to create a PPT with data in

No Thumbnail

Change Presentation ColorScheme(VBA for PowerPoint)

In this article I will explain how you can change the color scheme of a presentation using VBA for PowerPoint. Basically each presentation has one or more slidemasters. Slides that come after each slidemaster will inherit the properties of the slidemaster. By changing the theme

No Thumbnail

Create a Presentation in PowerPoint using VBA

The presentation object is the main object used in VBA for PowerPoint. If you are familiar with VBA for Excel, you can consider the Presentation object as the Workbook of the project. Access A Presentation Object: The presentation objects can be accessed through the Presentations collection: Access

No Thumbnail

Insert Image in a PowerPoint Presentation Using VBA

In this article I will explain how you can insert an image into a PowerPoint presentation using VBA. The code above inserts the image located in the path “C:\Users\Public\Pictures\Sample Pictures\Desert.jpg” onto slide number “2”. For more information about the parameters to the function please see

No Thumbnail

Copy Slides From One Presentation to Another (VBA for PowerPoint)

In this article I will explain how you can copy slides from one PowerPoint presentation to another using VBA. Example 1 This is the presentation with the macro before running the script: This the presentation with the slide we want to copy: Result: Preserve Formatting

No Thumbnail

How to Use VBA to Add Text To PowerPoint Slides

This article explains how you can add text to PowerPoint slides using VBA. Note unlike MS Word where you can add text anywhere in the document, in PowerPoint you can only add text inside text boxes. This is regardless of whether you are using VBA

No Thumbnail

Add and Delete Slides in Powerpoint Presentation Using VBA

This article explains how you can add and delete slides from a PowerPoint presentation object. Add New Slide The following code will add a new slide to the active presentation object: The first parameter specifies what index the new slide will get. So An index