Chapter 18: Working with PowerPoint in Excel VBA
Experience has shown by now that VBA is common to all the applications within the Office Suite. This means that data in an Excel spreadsheet can be automatically exported to PowerPoint as well.
The advantage of knowing how to use VBA to automate these tasks saves a lot of time. Instead of manually copying from Excel and pasting into PowerPoint, everything can be automated, using the appropriate procedures in VBA.
In this chapter, we will cover the following recipes:
- Creating a new instance of PowerPoint
- Creating presentations and slides
- Adding text to textboxes
- Copying Excel content into PowerPoint
By the end of this chapter, you will be able to initiate a PowerPoint slideshow from within Excel.
