Controlling Powerpoint from Excel using VBA

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

Using VBA to control other Office applications

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

Linking Excel files to PowerPoint

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