Run PowerPoint Macro from PowerShell

Question

I have a PowerPoint with the following macro:

Sub test() MsgBox "testing" End Sub

And a PowerShell script like this:

$ppt = New-Object -ComObject PowerPoint.Application $presentation = $ppt.Presentations.Open("test.pptm") $ppt.Run("test")

But running the macro just gives:

Cannot find an overload for "Run" and the argument count: "1". At line:1 char:1 + $ppt.Run("test") + ~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [], MethodException + FullyQualifiedErrorId : MethodCountCouldNotFindBest

I get the same error for e.g. $presentation.application.run("test") and $ppt.Run("test.pptm!test").

Passing a variant through COM object via PowerShell to run a macro in PowerPoint

The documentation suggests that Run should just take the macro name as a string as its first argument, so I can't see where I'm going wrong.

OverloadDefinitions ------------------- System.Object Run(string MacroName, [ref] Params System.Object[] safeArrayOfParams) System.Object _Application.Run(string MacroName, [ref] Params System.Object[] safeArrayOfParams)

Application.Run Method (PowerPoint)

Try passing an empty array as the second parameter? You might have to do "ModuleName.SubName" as the first param by the way — Jbjstam
– Jbjstam, Commented Jan 9, 2017 at 11:23
I've resolved my issue using Invoke-NamedParameter from stackoverflow.com/questions/5544844/… — StanleyKh
– StanleyKh, Commented Sep 18, 2023 at 14:45

sodawillow · Accepted Answer · 2017-01-09 11:25:08Z

0

Try this:

$ppt = New-Object -ComObject powerpoint.application $presentation = $ppt.presentations.Open("test.pptm") $ppt.Run("test", @())

answered Jan 9, 2017 at 11:25

sodawillow

13.3k4 gold badges36 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

user2987808 Over a year ago

Thanks, but that gives: $ppt.Run("test", @()) type must not be ByRef At line:1 char:1 + $ob = $ppt.Run("test", @()) + ~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : OperationStopped: (:) [], ArgumentException + FullyQualifiedErrorId : System.ArgumentException

sodawillow Over a year ago

Can you try with $ppt.Run("test", [ref]@())?

Steve Rindsberg Over a year ago

ISTR that you can call public subs in add-ins using just the name of the sub (ie, .Run("test") but if you want to call a sub from within a loaded PPT/PPTM file you need to use something like .Run("Test.pptm!test")

sodawillow Over a year ago

Both behave the same on my computer. When sub is not found, you get this error: Application.Run : Invalid request. Sub or function not defined.

Nicolas Malebranche · Accepted Answer · 2021-06-02 09:13:19Z

Based on this post:

$ppt = New-Object -ComObject PowerPoint.Application $presentation = $ppt.Presentations.Open("test.pptm") $presname = $presentation.Name $VBScript = New-Object -ComObject "MSScriptControl.ScriptControl" $VBscript.Language = "VBScript" $VBscript.AddCode( @" Function RunVBA( app, functionName ) RunVBA = app.Run( functionName, array() ) End Function "@ ) $VBscript.CodeObject.RunVBA( $ppt, "$presname!test" )

Note that this only works with Powershell x86, since ScriptControl is not available in a 64-bit environment.

Nicolas Malebranche · Accepted Answer · 2021-07-19 18:53:10Z

Accessing the Application object via the presentation works for me:

$ppt = New-Object -ComObject PowerPoint.Application $presentation = $ppt.Presentations.Open("test.pptm") $presentation.Application.Run("test")

Collectives™ on Stack Overflow

Run PowerPoint Macro from PowerShell

3 Answers 3

4 Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Linked

Related