Category Archives: PowerPoint

Mail Merge in PowerPoint using VBA, Excel Version.

A simple Mail Merge in PowerPoint As you can see in the above image we have merged employee data (id, first name, last name and a picture) stored in Excel into a slide in PowerPoint. In the previous post: https://pepitosolis.wordpress.com/2013/04/19/simple-mail-merge-in-powerpoint-using-vba/ we … Continue reading

Posted in Excel, PowerPoint | Tagged , , , , , , , , , , , , , , , , , , , | 13 Comments

PowerPoint VBA formatting a shape TextBox.

In PowerPoint to format a shape textbox requires to access methods like “Paragraphs”, “Words”, “Lines”, “Sentences”, “Characters”. By the way the first element is one (1) not zero (0). To change Font Color to Yellow for the first word .Words(1).Font.Color = … Continue reading

Posted in PowerPoint | Tagged , , | Leave a comment

Simple Mail Merge in PowerPoint using VBA

Let’s create a simple mail merge in PowerPoint using Visual Basic for Applications (VBA). Things you will need: 1. A table called “Employee” in a SQL Server Express 2012 database called “DB”. For Excel instead use this link: https://pepitosolis.wordpress.com/2013/05/10/mail-merge-in-powerpoint-using-vba-excel-version/ The … Continue reading

Posted in PowerPoint | Tagged , , , , , , , , , , , , | Leave a comment

Add or Remove Slides in PowerPoint with VBA

Adding a Slide to a Presentation Use the Add method of the Slides collection Add(Index as Long, Style as PpSlideLayout) The second parameter “Style” uses an Enum called PpSlideLayout. There are more than 30 styles to choose from. This code … Continue reading

Posted in PowerPoint | Tagged , , , , , , , , | Leave a comment

Macros or VBA in PowerPoint

The lack of a macro recorder in PowerPoint since version 2007 makes a little bit harder to either program macros or write VBA code. To program a macro or write VBA code, first you need to add the Developer Tab. … Continue reading

Posted in PowerPoint | Tagged , , , , | Leave a comment

Delete Paragraph PowerPoint VBA.

To delete a paragraph use: Shape.TextFrame.TextRange.Paragraphs(n).Delete Where “n” is the paragraph’s number. Starts in one (1). Another example, this deletes the second paragraph for all shapes in the current slide:

Posted in PowerPoint | Tagged , , , | Leave a comment