VBA Made Easy: Episode 03 - Integrate PowerPoint and Excel using VBA

Learn how to integrate Excel and PowerPoint to build slides from Excel Data
Visit this folder to download the Code Modules:

00:00 - Intro
00:05 - Previously on VBA Made Easy
00:26 - This Episode
00:55 - Seeing the Example
01:42 - What is a Class Module
02:18 - Code Breakpoints
03:02 - Dimensioning PowerPoint
03:18 - What is a Collection?
04:16 - Running the Code
04:34 - Looping through the Data
05:02 - Instancing a Class
05:11 - Populating the Class with Data
05:43 - Adding the Class to a Collection
06:33 - Creating an Instance of PowerPoint
06:42 - Stopped Here
06:50 - Opening a PowerPoint Presentation
07:27 - Add a Table to PowerPoint
08:09 - Adding Data to the Table
08:31 - Commenting Out Code
11:03 - Concatenating Strings to Form a URL
11:51 - Deleting a File with VBA
12:01 - Using a Windows API Call to Download an Image from the Web
13:38 - Inserting an Image into PowerPoInt
14:13 - Automating Column Width in PowerPoint Table
15:11 - Centering an Object in PowerPoint
15:23 - Running a PowerPoint Presentation
15:37 - Saving a PowerPoint Presentation
15:47 - Clearing Breakpoints