Creating a new instance of PowerPoint
The process of setting a reference to the object library with Word is similar to that of PowerPoint. Hence, the same must be done with PowerPoint, or else Excel cannot communicate with PowerPoint at all.
In this recipe, we will be creating a new instance of PowerPoint from within Excel.
Getting ready
Open Excel, and activate a new workbook. Save the file as a macro-enabled file on your desktop and call it PPoint_Interaction.xlsm. Sheet1 should be active. Press Alt + F11 to switch to the VBA Editor, and then insert a new module.
It is a prerequisite that MS PowerPoint must also be installed on your computer in order for the instructions in this recipe to work effectively.
Note
In this chapter, we will only cater to the latest version of MS Office. Coding for previous or legacy versions is not covered.
How to do it…
Here is how to link PowerPoint to Excel:
- In the VBA Editor, click on Tools | References. The...
