The code below is intended to be a basic reference to anybody trying to use VBA code for Powerpoint. It’s certainly not complete, but it is code I’ve used for various reasons. I will try to add to and improve this reference as I use more PowerPoint VBA code. Referencing presentations, slides and shapes ‘Set … Read more
So far in this series about using VBA to control other Office applications, we have looked at the basics of controlling other office applications and specifically how to create macros to control Word from within Excel. Our approach for creating macros to control Word was using the Macro Recorder. We record very short actions, copy … Read more
Whilst this site is primarily about using Excel, there are times when Excel is not the best tool for the job. Each Office application is designed for different tasks. Tables and charts may be easily prepared in Excel, but they are often exported to PowerPoint, Word or Outlook for the purposes of presentation and distribution. … Read more
In a previous post, we considered how to link Excel files to PowerPoint presentations. This can be a significant time saver as the PowerPoint presentation can be updated automatically. Once you have created the links, life is brilliant, until . . . you need to change which file the PowerPoint presentation is linked to. You … Read more
If you regularly create PowerPoint presentations that include information from Excel, you will know how frustrating it can be. Having to re-copy and re-paste the information every time a change is made in the original Excel documents. Have you come across the feature which enables you to link your Excel workbook directly into your PowerPoint … Read more