Training videos for learning VBA LINKING APPLICATIONS

VBA linking applications - 5 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.

Excel VBA Part 29.1 - Creating Outlook Emails

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 emails in Microsoft Outlook by writing code in Excel. You'll learn how to reference the Outlook Object Library, several methods for creating a new instance of the Outlook application and how to create new emails. You'll see how to set basic properties of an email, such as the address and subject and also how to add attachments and make sure that the email includes a signature. The video spends a lot of time talking about the different email formats and how to set the body text of the email according to which format you've chosen; this includes how to write plain text emails, and how to construct basic HTML emails including how to format them. Towards the end the video also shows how to write emails using the Word Editor, allowing you to copy and paste information directly from Excel.

Excel VBA Part 29.2 - Outlook Email Events

Posted by Andrew Gould on 29 August 2017

This video explains how to use the WithEvents keyword to access the Send and Close events of an Outlook MailItem. You'll learn how to use a basic class module to enable access to the events of an object, as well as how to create basic event handlers.

This page has 0 threads Add post