Using PowerPoint to Call Excel?

[Guest]

I would like to have my PowerPoint presentation be able to start Excel and
run a macro on it. I would like for this to occur after a certain slide has
been reached. Is this possible?

 

[Steve Rindsberg]

I would like to have my PowerPoint presentation be able to start Excel and
run a macro on it. I would like for this to occur after a certain slide has
been reached. Is this possible?

Yes.

First, if you're not already familiar with automating one app from another,
google "automate excel" and similar variations to get example code that you can
use in PPT.

I think you need to use Application.Run to fire off the Excel macro from an
external app.

As to firing it when a certain slide has been reached, the simplest thing to do
is use an action button to advance to the target slide from the previous slide;
the action button advances the slide and fires off the excel macro.

 

[Brian Reilly, MS MVP]

Another approach from the excellent approach that Steve mentioned
would be to use a button on a given slide to open the Excel file and
name the Excel macro Auto_Open

e.g.

Option Explicit

Sub Auto_Open()
MsgBox "I' open."
End Sub

This will fire the macro when the worbook opens.

Brian Reilly, MVP