Macros

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 …

How to Get the Slide Width in PowerPoint using VBA

How to Get the Slide Width in PowerPoint using VBA
When we created our add-in for PowerPoint to export slides as images we faced an interesting challenge. Aside of choosing a specific output size, we needed to get the actual size of the PowerPoint presentation while iterating through each slide. This way we were able to calculate the new width and height (and aspect ratio) …

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 …

Using VBA to Export PowerPoint Slides to Images

We already have posted about how to use C# to programmatically export your slides to images, but today we’d like to show you an easy way to export your active presentation to images using VBA code. This can be very handly if you want to make a PowerPoint add-in using VBA and Macros and for example …

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, …

Business Loan Analysis Template (Loan Tree) With Loan Approval Process

business-loan-analysis-template-with-loan-approval-process-1

If you are planning to start a business venture but you lack capital, it may be a good idea for you to apply for a loan from a bank. Many businesses get funding this way. However, banks have strict requirements and they may need to look into your financial standing and other criteria before they …

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 …

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 …

Page 1 of 212