Visual Basic for Applications (VBA) in Microsoft PowerPoint
15
votes
2answers
1k views
How to invoke an action during powerpoint slideshow programmatically?
I am automating a Powerpoint scenario using Coded UI & VSTO. In my powerpoint presentation I have created an 'Action' setting on a shape to launch notepad. During slideshow I need to invoke this ...
8
votes
3answers
12k views
VBA error 1004 - select method of range class failed
First time poster, so if there is any formatting, or guidelines I failed to adhere to, please let me know so that I can fix it.
So I am basically asking the user for the file directory of the excel ...
6
votes
4answers
2k views
Is there a future for PowerPoint VBA/VSTO?
Does anyone know what the future holds for VBA/VSTO programming in PowerPoint? I've been working on a Office automation project and find it frustrating to work with PowerPoint in particular since it ...
6
votes
1answer
237 views
Change font of a Non-English TextBox
Please consider the following piece of code
With ActivePresentation
Set sldNewSlide = .Slides.Add(.Slides.Count + 1, ppLayoutBlank)
With sldNewSlide
Set shpCurrShape = ...
5
votes
3answers
12k views
Renaming Objects in PowerPoint
Probably a very stupid question but I can't figure how to rename an object in PowerPoint.. For example, all my Graphs are called by default "Graph 1" etc.
Could someone help me on that?
Thanks!
5
votes
3answers
2k views
What tutorial you would recommend to study PowerPoint VBA?
I feel I lack some real basics and I feel I would waste your time if ask all those basic questions here. Can you please recommend a good PowerPoint VBA tutorial that would explain basics to me. A ...
5
votes
2answers
7k views
How to name an object within a PowerPoint slide?
So I know how to name a textbox, or a like object in PowerPoint with VB, but I was wondering if there was a way to name objects through the Ribbon (PowerPoint 2007). For instance, if I add a text box ...
5
votes
2answers
879 views
Branching Slides in PowerPoint (VBA)
I am trying to create a back button but using hyperlinks it simply just takes me to the previous page and ends up in a loop... e.g. if I have slide 1 which has links to slide 3, 4 & 5 then slide 3 ...
4
votes
3answers
7k views
Apply Font Formatting to PowerPoint Text Programatically
I am trying to use VBA to insert some text into a PowerPoint TextRange, I use something like this:
ActiveWindow.Selection.SlideRange.Shapes("rec1").TextFrame.TextRange.Text = "Hi"
However, I can't ...
4
votes
2answers
6k views
PowerPoint VBA: which command (or a set of commands) would create ppt frames out of my .jpg pictures?
I have a few .jpg files in C:\my_folder
Here are their names: pic_1.jpg , pic_2.jpg , pic_3.jpg , pic_4.jpg , pic_5.jpg .
What command or a group of commands in Power Point VBA should I use in order ...
4
votes
1answer
407 views
Trapping a DoubleClick in PowerPoint 2007
The Application.WindowBeforeDoubleClick event for PowerPoint 2007 appears to not work (see here to verify my claims). It works in PowerPoint 2003, but not in 2007 (contrary to the documentation).
I'm ...
4
votes
2answers
1k views
Call subroutine when a specific slide loads, or on a timer
I'm working with a PowerPoint 2003 presentation for a kiosk display, and it is left running pretty much 24/7. One slide on it has the weather, the current date, and the 7 day forecast.
I've already ...
4
votes
1answer
693 views
Removing Speaker Notes from Presentations Programmatically
I have a lot of presentations that need to be shared outside of my company and I need a way to loop through all the speaker notes and remove them automatically. Is there a way to do this in VBA? I've ...
4
votes
1answer
490 views
How add text in PowerPoint which on click is replaced by a cursor?
Everybody knows "Click to Add Title" in the first page of the PowerPoint slide - the moment you click on it, the text disappears. This is very useful feature for creating templates. Does anybody know ...
4
votes
1answer
804 views
How do I get Powerpoint to call my VBA subroutine in an animation?
What I ultimately want to do is ShellExecute() a command-line program every time a new slide appears in my PowerPoint slide show. I'm using Office 2003 PowerPoint.
I did the following:
Tools > ...
