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.
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!
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.
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.
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.
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.
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.
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.
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.
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.
Posted by
Andrew Gould
on 22 December 2021
This video explains how to get a reference to an open Word document using Excel VBA. You'll learn how to use the GetObject function to reference a running instance of Word and how to add error handling code to deal with occasions when Word isn't running. You'll also see how to quit the application, close all documents leaving the application open, close a single document and how to loop through the documents collection.
Posted by
Andrew Gould
on 20 February 2022
Learn how to loop through PowerPoint files and copy all the slides from each presentation into a single file using the InsertFromFile method.
Posted by
Andrew Gould
on 29 July 2022
Learn how to loop over the rows of an Excel list and generate a new PowerPoint slide for each one.
Posted by
Andrew Gould
on 21 October 2023
This video explains how to use VBA to insert video and picture files into PowerPoint slides by looping through a list in an Excel worksheet.
