How can we run a pre-written macro in multiple power point files? Is there any way I can automatically embed a Macro in ALL Powerpoint documents

nishakankaria · December 13, 2018, 4:39am

I have created a macro in PowerPoint and I want to run the same for multiple power point files. Is there any activity that can run/execute macro in power point? Or open PPT and run a pre-written macro in multiple ppt files?

neonova · December 13, 2018, 4:52am

@nishakankaria
No activity as such for Powerpoint (unless someone made a custom one) but a workaround could be using sendhotkeys if the developer ribbon is visible

or using an Autoit Script

But no direct functionality as such

Syeda_Kunza · November 16, 2020, 6:18am

Hi @nishakankaria , did you find a solution for the same?

Syeda_Kunza · November 16, 2020, 6:21am

Hi @neonova, Could you please help me out with this procedure in a more detailed way? Would be of great help!

Thanks!

Cristian_Negulescu · March 21, 2021, 8:08pm

Hello Syeda,
In this video, I have multiple use cases of UiPath working with POWERPOINT via VB.NET:

1:10 Install NuGet Package for automation
4:00 Use-Case 1 Add a new slide and add a picture
8:20 Add Chart
10:35 Add a text with shadow
12:30 Perform a slideshow
15:00 Delete slide and Export to PDF
17:30 Working with comments (Add, Read, Delete)
19:50 Create a complex PowerPoint from 0

Code:

github.com

cristinegulescu/startUiPathFromSalesforce/blob/master/PowerPointCODE.txt

'VB.NET code that call POWER POINT

'ADD SLIDE WITH TEXT AND PICTURE

        Dim oApp As Microsoft.Office.Interop.PowerPoint.Application
        Dim oPres As Microsoft.Office.Interop.PowerPoint.Presentation = Nothing
        Dim oSlide As Microsoft.Office.Interop.PowerPoint.Slide = Nothing

        'Start Powerpoint and make its window visible but minimized.
        oApp = New Microsoft.Office.Interop.PowerPoint.Application()
        oApp.Visible = Microsoft.Office.Core.MsoTriState.msoTrue
        oPres = oApp.Presentations.Open("C:\R\power.pptx",,,)
        oApp.WindowState = Microsoft.Office.Interop.PowerPoint.PpWindowState.ppWindowMaximized

        'Add Slide with text
        oSlide = oPres.Slides.Add(1, Microsoft.Office.Interop.PowerPoint.PpSlideLayout.ppLayoutTitle)
        With oSlide.Shapes.Item(1).TextFrame.TextRange
            .Text = "My Sample Presentation"
            .Font.Name = "Comic Sans MS"
            .Font.Size = 48

This file has been truncated. show original

Thanks,
Cristian Negulescu

Topic		Replies	Views
Multiple use-cases of PowerPoint Automation with UiPath Video Tutorials powerpoint , script	0	1489	March 22, 2021
Execute Macro Activity in UIPATH for Microsoft Powerpoint Feedback	6	2571	September 25, 2019
Execute PPT Macro-UiPath Something Else feedback	2	747	June 23, 2021
Can automate a powerpoint Help	3	2472	March 21, 2021
How to automate powerpoint in uipath Help	14	7147	May 28, 2021

How can we run a pre-written macro in multiple power point files? Is there any way I can automatically embed a Macro in ALL Powerpoint documents

Related topics