Macro

What is a Macro?

You might have downloaded an Office template and received a prompt to enable macros. You might also have noticed that the prompt also comes with a warning that enabling macros can be harmful for your computer. But macros aren’t exclusive to Microsoft Office files, as a macros are widely used by programmers around the world …

Get & Save Settings to the Registry using PowerPoint VBA

Get & Save Settings to the Registry using PowerPoint VBA

If you are writing your own macros and VBA code in PowerPoint, especially if you are creating a PowerPoint add-in, sometimes you might find useful to get and save your settings globally. In Windows, the Registry is a good place to save this kind of settings. Today we will learn how to use PowerPoint and …

How to Create a PowerPoint 2010 Add-In using VBA with Custom Buttons in the Ribbon

This tutorial will give you a better idea how to create your custom PowerPoint 2010 Add-Ins using VBA code and creating a custom toolbar in the ribbon so you can call macros. This kind of add-in let you do multiple useful actions for example we can create a tool to export the presentation to PDF, …

VBA Macro: Save a PowerPoint Presentation To PDF Programmatically

VBA Macro: Save a PowerPoint Presentation To PDF Programmatically

If you need to save a PowerPoint presentation to PDF format programmatically using VBA code, here is a simple macro to do the job. This macro snippet will make possible to save the active presentation to an output PDF file in the same path where you have the presentation saved.

VBA Macro: Rename a Shape Name

Sometimes you’d need to rename a shape object from the default name to any desired name. Especially if you will deal with VBA code in the future and want to use more descriptive names for shapes and objects. This snippet will help you to rename objects easily using a Macro. To use it, just create …

Convert Excel to PowerPoint with Excel2PowerPoint

Excel to PowerPoint is an interesting open source project available in SourceForge that you can use to convert an Excel spreadsheet into a PowerPoint presentation. The application is bundled inside an Excel spreadsheet using Macros. As soon as you download the project from the online repository, you will need to unzip and open Excel To Powerpoint.xls …

Using PowerPoint Scripts & Macros

PowerPoint and other Microsoft Office programs comes with VBA, Visual Basic for Applications. VBA is an implementation of Microsoft’s event-driven programming language Visual Basic 6 and let you run scripts and macros in the popular Microsoft Office applications. VBA enables building user defined functions, automating processes and accessing Windows API and other low-level functionality through dynamic-link …

Running a VBA Macro When a PowerPoint Opens

Running a VBA Macro When a PowerPoint Opens

If you need to start a Macro automatically when a PowerPoint .ppt or .pptx file opens, then here are some tips that can be helpful to accomplish the need. There is a free addin AutoEvents that enables PowerPoint to run macros automatically on certain events. You can download the addin from http://skp.mvps.org/autoevents.htm and it will be helpful …

How to open VBA Macro editor in PowerPoint

In Excel it is straightforward the way to open VBA Editor to edit macros and functions. In PowerPoint you need to do something slightly different. However, it is pretty easy. In PowerPoint 2010 you can just create a new Macro by going to View tab and then click on Macros button. Here a new list of Macros will …

Page 1 of 212