Controlling Word from Excel using VBA

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 Excel VBA to Control Office Thumb

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

Edit links in Powerpoint using Excel VBA Thumb

Edit links in PowerPoint using VBA

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

Edit links in Powerpoint using Excel VBA Thumb

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