Using VBA to read Powerpoint slides

(0) Share

Report

Posted on by vince33

Hello all,

I would like to create a simple flow.

First step, the user selects a file (PPT file)

Second step is a VBA script that has to read slide titles and output a list of slides in a custom form

My VBA script looks like:

Set selectedPres=Presentations.Open("%SelectedFile.FullName%")
Set selectedSlides=ActivePresentation.Slides
For Each slide In selectedSlides
	...
Next

When I execute, I got "Presentations object is required". How get I get my script to know about this object?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

VJR 7,635 on at

Like (1)

Report
Copy link

Link copied!

Hi @vince33 ,

Just to clarify on certain terminologies - VBA (Visual Basic for Applications) and VBS (VBscript) are two different things.

For accessing via Power Automate Desktop, a VBA code can be written as an Excel macro and then called via the "Run Excel Macro" action of PAD (Power Automate Desktop).

(Note that a VBA code can be written inside Word, Powerpoint, Outlook, etc) but PAD does not have an action yet to call them from within these applications.)

Whereas, a VBS can be written within PAD itself in the Run VBScript action.

-------------------------

What you have written seems to be a VBS (and not VBA).

In either cases you will find the exact code if you search with the right keywords and terminologies.

As an example of VBS, below is one to modify the title of a PPT.

VBScript - Modify the Title of a Microsoft PowerPoint Slide (vbsedit.com)

Was this reply helpful? Yes No
vince33 19 on at

Like (1)

Report
Copy link

Link copied!

thank you very much for clarifying my confusion between vbs and vba.
This was my main issue

Was this reply helpful? Yes No