Training videos for learning VBA - LINKING APPLICATIONS

We have 10 VBA - linking applications videos listed below. You might also like to consider booking a place on one of our online or classroom VBA courses, where you will meet the owls behind the 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.

How do I copy Excel data into PowerPoint using VBA?

Posted by Andrew Gould on 03 April 2021

Learn how to write VBA in Excel to copy a table into PowerPoint. You'll see how to paste as a PowerPoint table, as a picture as plain text, as RTF text, as an embedded Excel object and as a linked Excel object.

How do I paste Excel data into an existing text box in PowerPoint?

Posted by Andrew Gould on 03 April 2021

This video shows you how to paste Excel cells as text into an existing text box in a PowerPoint presentation. You'll learn about the TextFrame and TextFrame2 properties of a text box, how to reference the TextRange within a text frame and how to use the Paste and PasteSpecial methods to paste as plain text and RTF text.

How do I paste and resize a picture in Word from Excel VBA?

Posted by Andrew Gould on 03 April 2021

Learn how to copy Excel data and paste it as a picture in a Word document. You'll see the difference between inline and floating shapes and how to resize both types by referencing the relevant shapes collection.

What's the difference between early binding and late binding in VBA?

Posted by Andrew Gould on 15 April 2021

You may have written VBA code in Excel to reference another application by setting a reference to the application's object library. Did you know that you don't need to reference an application's object library to write code to control it? This video explains how to do this by switching from early binding to late binding in order to create a new Word document from Excel. You'll learn what changes you need to make to your code to allow this, how to use the CreateObject function and why late binding is so useful if you're sharing code with other people who may not be running the same version of an application as you.

How do I resize a Word table after copying from Excel?

Posted by Andrew Gould on 05 May 2021

If you copy data from Excel to Word what happens if the table is too big for the page? This video shows you how to control the width of table columns in Word to make sure that everything fits on the page.

How do I copy Word tables into Excel using VBA?

Posted by Andrew Gould on 12 May 2021

This short video explains how to use VBA to copy all the tables in a Word document into an Excel workbook. You'll learn how to paste as an embedded Word document object, as plain text and as formatted HTML text.

Excel VBA - How do I create a header with a logo in Word using VBA?

Posted by Andrew Gould on 05 August 2021

Learn how to use VBA in Excel to create a Word document with a page header and how to insert an image into the header. You'll see how to create different headers for odd and even pages and for the first page in the document.

This page has 1 thread Add post
17 Sep 20 at 19:03

My question is this: if I link either a table or a chart from Excel to PowerPoint 2007 using VBA I can't set lockaspectratio to false permanently. This is equivalent to using sizing using ribbon. But if I manually right click on the object and choose format - lockaspectratio - uncheck, it works.

Please provide VBA code to do set lockaspectratio to false for linked objects permanently in PowerPoint 2007.

17 Sep 20 at 19:54

Afraid we don't have time to provide additional code, but perhaps any other reader could help?