Greetings everyone

I am trying to call a macro in PowerPoint from the command line to simplify things for my team at work.

Trying to keep it simple this is the code I am working with so far:

Set pptApp = CreateObject("PowerPoint.Application")
pptApp.Run "Presentation.pptm!UpdateLinks2Local"

I get the following error:

Row 2
Character 1
Error: Application.Run : Invalid Request. Sub or function not defined.
Code 80048240



I'm running this on Windows Vista Enterprise with Office 2010 standard 32-bit

I wouldn't know what function or sub to put there.

Please let me know if I can explain anything further.

Thanks in advance!

Presuming Presentation.pptm is open and the sub exists that depending on what you mean by command line that should work.

It's probably not the way to do it though. Why not create a ppam AddIn that creates a ribbon button to run the code on any active presentation?

__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials

Thank you for your response.

My apologies I should have clarified that it I don't want the file to open. It would be nice to have it run in the background somehow because when the file opens it prompts the user to update the links or not before the macro runs. For Excel an example is:

objExcel.Application.Run "Presentation.pptm!UpdateLinks2Local"

I would like that (above) functionality but for PowerPoint.

My main goal is that a user can run this unattended, as it takes 3-5 minutes to update everything. The intention to be able to run the script to update the PPT just before a presentation to a client.

I don't think the code will run in PPT if it is cl;osed.

You may be able to open the presentation in code and NOT trigger the usual link update

Sub fixme()
Dim thisPres As Presentation
Set thisPres = Presentations.Open("C:\Users\John\Documents\Presen tation1.pptm", WithWindow:=False)
With thisPres
'do whatever
End With
End Sub

__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials

I found a working solution of calling a macro from VBScript.

Here is the code that does what I need. Which is to open the PPT file and perform the macro. I don't get prompted to update links.

Unfortunately PPT must open to perform the macro but I'll just have the macro close PPT once it's finished or have it call on another macro to close it.

The code would only work with the 3rd line that duplicates the slide but it all functions well. The link below discusses further on this strange anomaly.

I am open to any suggestions or ideas if anyone has any.

http://help.lockergnome.com/office/c...ict469171.html


Thank you for your responses JohnWilson!