VBA – Run a PowerPoint Macro using Excel VBA – How to Code Examples

Below is a demonstration of using PowerPoint.Application to open a PowerPoint file and then run a macro that is stored within the PowerPoint file.

  1. Make sure you modify “fullpath\p1.pptm” and point it to the full path-filename to your PowerPoint file.
  2. Modify the macro name. Macro name must be full macro name with file, module and macro name in your PowerPoint file in order for this script to work. Use the following format “p1.pptm!Module1.name”

 

Posted by Excel Instructor:

http://www.chicagocomputerclasses.com/excel-classes/