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