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
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
In this article I will explain how you can use VBA for excel to sort a range of cells. Example 1: Consider the range below. Assume we want to sort the range in ascending order based on column A:The following code will filter based on
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
In this article I will explain how you can add all the images from a target folder to a power point presentation using VBA. Step 1: Get all Files in a directory The first step is to write a code that will retrieve all files
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
In this article I will explain how you can use VBA for Excel to create pivot tables. Create New Pivot Table: The following code will create an empty pivot table. The function receives as input a source range, and an output range. The source range
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
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