Training videos for learning VBA - LINKING APPLICATIONS

VBA - linking applications - 3 videos

Excel VBA Part 27.1 - Creating Word Documents

Posted by Andrew Gould on 21 March 2014

Writing VBA code in Excel doesn't only allow you to control Excel, you also have access to all of the other Office applications. This video looks at how to create documents in Microsoft Word by writing code in Excel. You'll learn how to reference the Word Object Library, several methods for creating a new instance of the Word application, how to create new documents and how to copy data from Excel into Word. You'll also learn the importance of testing for which version of Word your users are running and how to write version-independent code that will work with (almost) any version of Word.

Excel VBA Part 27.2 - Creating and Updating Linked Word Tables

Posted by Andrew Gould on 07 November 2016

Using Excel VBA to create a linked table in a Word document is pretty straightforward. Where things get tricky is when you move or rename the original Excel file. This video explains how to create the original linked table followed by how to update all of the links in a Word document by looping over its Fields collection. The end of the video also shows how to attach the code to the save events of the workbook so that you don't even have to remember to run it yourself!

Excel VBA Part 28 - Creating PowerPoint Presentations

Posted by Andrew Gould on 26 March 2014

Writing VBA code in Excel doesn't only allow you to control Excel, you also have access to all of the other Office applications. This video looks at how to create presentations in Microsoft PowerPoint by writing code in Excel. You'll learn how to reference the PowerPoint Object Library, several methods for creating a new instance of the PowerPoint application, how to create new presentations and insert slides and how to copy data from Excel into PowerPoint. You'll also learn the importance of testing for which version of PowerPoint your users are running and how to write version-independent code that will work with (almost) any version of PowerPoint.

This page has 0 threads Add post