All Questions
Tagged with vba microsoft-powerpoint
57
questions
0
votes
0
answers
174
views
How can I recover vbaproject.bin from my corrupt powerpoint.pptm file
I have a .pptm file with 70 hours of code work in it. It has become corrupted and I have no backup (very stupid I know!). What I do have is the .ppam which was generated from a slightly earlier ...
- 1
0
votes
1
answer
61
views
PowerPoint VBA - Slide Show - Win11 not updating Slide Content
I have a PPT slide deck (2 slides) saved as a PPTM file that are used as a countdown timer where the time remaining is controlled by VBA on slide 2.
It used to work properly when I was on Windows 10 ...
- 89
0
votes
0
answers
2k
views
Extract All Comments from PowerPoint File into a Text file
I have a monthly PowerPoint reports that I create with relevant notes in the PowerPoint notes section. I would like to just extract these notes from the PowerPoint files over the years. Is there a VBA ...
- 1,708
0
votes
1
answer
1k
views
Merge PowerPoint Presentations Slide By Slide as Animation
I have 12 PowerPoint presentations (one for each month) with same number of slides and each slide contains similar reporting info/trends/tables for the corresponding month. I would like to merge all ...
- 1,708
0
votes
1
answer
165
views
PowerPoint: How to manipulate narration timings for on-click animations (not just advance to next slide)?
I'm using Office 365, version 2206 of PowerPoint, but this question applies to several versions. When you record narrations in PowerPoint, this feature allows you to set timings for advancing ...
0
votes
3
answers
509
views
Powerpoint slides (shapes) don't seem to inherit alternative text from master
I would like to replace an element in my powerpoint slides to have a sense of document property variables. I do have the macro in place, and it works.
But I don't understand why slides created, and ...
- 242
0
votes
0
answers
38
views
Select specific slides from existing .PPT from a required index in excel document, can this be done? [duplicate]
How can I select relevant slides only from .ppt from an excel index (below)?
Has anyone solved this?
0
votes
1
answer
62
views
Update combobox in Add-in menu with new value
I have put together a PowerPoint add-in that helps with updating some document properties. The "updating" of the properties works find with the callback routine I have in place for the combo ...
- 1
0
votes
1
answer
360
views
How can I highlight a specific part of a MS powerpoint slide by clicking an action button in another slide?
I am creating a presentation using MS Powerpoint. Is there any way that if I click an action button in one slide, I can go to other slide while a specific part of that slide is highlighted or have a ...
- 155
0
votes
1
answer
309
views
Compile Error: Create PowerPoint Slide for Each Row in Excel
I am absolutely new at VBA. What I want to do is exactly same with this person
Excel data into PowerPoint slides
make slides at ppt for each row of excel
make texts box at each slides for columns of ...
0
votes
1
answer
119
views
Excel Bulk Save Images through Powerpoint, .Shapes.SaveAs not working
I need to bulk same images embedded in Excel to original resolution. I found this code on internet, but it's not working and needs modification.
It gives an error at .Shapes.SaveAs
The images are ...
- 3
0
votes
4
answers
765
views
PowerPoint 2013(6): set slide timings to narration durations
I accidentally ran Clear Timings on All Slides command and lost all slide timings.
However, each slide of my presentation has narrations.
Is there a GUI/VBA way to set slide timings to narration ...
- 130
0
votes
1
answer
242
views
VBA PowerPoint author protect
I know from the Excel, that it is possible to write a VBA to protect the author name, so no one can change it and take credit for your work.
I have once read that the Excel VBA is something like when ...
0
votes
1
answer
1k
views
Manually run macro in powerpoint presenter view
TLDR: Can't run macros from powerpoint presenter view. If you're not interested in the background, just skip right to "What is not working".
I've painstakingly created some macros that I want to run ...
- 444
1
vote
0
answers
3k
views
What is the short cut to change the pen color in PowerPoint?
While I am presenting I would like to change my pen color and annotate on my slides. Is there way, I can find the hotkeys to change the pen color in Microsoft PowerPoint?
If there is no keys in ...
- 125
0
votes
1
answer
1k
views
Select all lines in PowerPoint
I have a bunch of PowerPoint slides I need to reformat, and I'd like to figure out a way to select all lines on the page - including those with arrowheads.
I found this post that included some VBA ...
- 187
1
vote
0
answers
393
views
Excel VBA: How to Create Word Handouts via PowerPoint VBA?
Sorry if title is confusing. I'm trying to execute a multi-app sub that will ultimately e-mail a PDF attachment. The process first starts by extracting information from a CSV, which I've done, then ...
- 103
0
votes
1
answer
2k
views
How to get large Excel table to paste into multiple slides using vba?
I am new to this forum, and new to VBA. I am working with a very large Excel table (200+ rows) where I have added a code in to identify page breaks based on when a value changes in one of the columns. ...
2
votes
1
answer
739
views
PowerPoint VBA addin (ppam) fails to load for all users
I have a PowerPoint VBA addin (ppam file) which is packaged in an MSI installer for installation for all users of a machine. Following installation, a user gets some additional buttons in the ...
- 141
3
votes
2
answers
10k
views
Is there a way to delete the text within multiple PowerPoint shapes?
I use PowerPoint almost daily as part of my job for reporting. Instead of using text boxes, we like to use Shapes with text inside it to put across ideas e.g. text statements or percentage figures. ...
- 35
0
votes
1
answer
893
views
Vba code to set the margin of selected text in indent level 2
Hi I have the following mention code which sets the indent level for second paragraph . I have two issues with this code.
On selecting more than one paragraphs the indentation will work only on Last ...
0
votes
1
answer
2k
views
VBA - Copy chart from excel to powerpoint without link (embed)
I have a macro that copies all charts from my Excel sheet into a new PowerPoint file.
The problem is that the charts update themselves if I use a filter while the Excel file is open. To prevent it, ...
- 1
2
votes
2
answers
2k
views
Extract Text from Powerpoint
So, I have found this nice Script here:
http://www.pptfaq.com/FAQ00274_Export_Text_to_a_text_file-_extract_text_from_PowerPoint_-Mac_or_PC-.htm
(I'm using the second one)
The import part is this:
...
- 31
1
vote
3
answers
865
views
Prompt for password when exiting presentation
Is it possible to prompt for a password when exiting a full screen presentation in Microsoft PowerPoint?
I need to be able to show a presentation constantly, whilst leaving my computer, but do not ...
- 7,485
0
votes
2
answers
350
views
PowerPoint animation or VBA issue: one name, picture appears, disappears, second name appears in the same place
I have been playing with animations in PowerPoint, but this relatively simple thing seems to be beyond my range. I want on the first (title) slide, one name with his details to appear below, then ...
- 1
1
vote
1
answer
3k
views
VBA error: -2147188160 when PasteSpecial a Shape
I've a vba procedure that call another procedure (addChart(cht, PptApp, oPres)), to add charts to a powerpoint presentation. When I run the full code, the procedure create a new ppt and paste the ...
- 111
1
vote
0
answers
1k
views
Change font of selection in PowerPoint
I am trying to create a very small macro to change the format (text size and font) in Powerpoint.
I have tried using this code taken from a similar question on StackOverflow. The code works, just ...
- 13.4k
0
votes
1
answer
124
views
How to skip an item in an array in a copy macro from Excel to PowerPoint
I'm new here with something that has had me stumped for weeks.
I have a macro that copies excel ranges from a sheet to a pre-prepared PowerPoint slide, and this is done using an array like below:
...
1
vote
2
answers
386
views
PowerPoint VBA - way to put Tag on Cell to identify
I'm trying to test automation capability of MS PowerPoint using VBA.
For my requirement, any table cell MUST be marked by controlled ID and referred back by using this ID. However, I couldn't fint ...
- 11
0
votes
2
answers
765
views
How do I update the slide master from Slideshow Mode and refresh current slide using VBA?
I'm trying to have a counter in all slides of a powerpoint presentation.
The counter needs be controlled a button in all slides that increases it.
I can do it for one specific slide, but when I do it ...
- 101
3
votes
1
answer
1k
views
VBA Pulse Animation in PowerPoint 2013 using Excel 2013
I hope I'm in the right SE. The posts I found directed me to post here.
BLUF: I am trying to use an if/else statement to apply/remove the pulse animation on a specific object in PowerPoint.
...
- 41
13
votes
7
answers
47k
views
Go to a specific slide in powerpoint when creating the slides
This might be very simple to achieve, but I don't know how to see it through.
When I create presentations using MS powerpoint, I have to go from slide to slide (say from Slide 3 to slide 45). So far I ...
- 4,094
0
votes
1
answer
1k
views
In PowerPoint VBA, how to use `TextRange.Runs.Font.Bold` to insert `<b>` and `<\b>` tags around the returned text range? [closed]
I'm using VBA in Powerpoint to find styles in the text and then wrap that text with HTML markdown tags. Below is the code I'm trying to use to find bold text and then wrap it in <b>bold text</...
- 13
1
vote
1
answer
4k
views
Excel VBA - Loop throught powerpoint shape and identify text line not in Excel range
I'm writing a macro to identify if the text lines in a PowerPoint shape are not present in an Excel range.
The idea in the last loop is that if the text line in the shape is not found in the Excel ...
- 13
0
votes
1
answer
2k
views
Import images from folder to PowerPoint Slide Master container
I have a folder of 1,500+ jpg images, I need to import them to a specific container in new slides in PowerPoint. The Photo Album tool doesn't have the customization I need. In the past (with less ...
- 101
1
vote
1
answer
2k
views
VBA in Mac: Create PowerPoint Slide for Each Row in Excel Workbook
I am absolutely new to VBA. I am trying to create a presentation such that content of each cell (in a row) creates a new slide in the presentation.
I searched for the code, but I could only find it ...
- 11
0
votes
1
answer
556
views
Powerpoint Reusing Objects
I want to create a ppt with lots of pictures and audios, which will be reused many times. For example, I will have a chime that will play on each slide load. I don't want the same image or audio to be ...
- 15
1
vote
1
answer
3k
views
PowerPoint VBA - Run Macro When Slide Changes in Edit Mode
I know I could do the following to run code when the slide is changed in presentation mode -
Sub OnSlideShowPageChange()
Dim i As Integer
i = ActivePresentation.SlideShowWindow.View....
user613286
0
votes
1
answer
91
views
Deleting pictures from slides since last save
Please bear with me as I explain, hopefully succinctly, my question. I have a user form that, among other things, allows the user to insert a picture into a subset of sets in the project [i.e., slides ...
- 1
1
vote
1
answer
2k
views
VBA Solution: Microsoft Excel/PowerPoint rename active file, choose folder to save in desire location and delete old version
I am looking for a VBA solution for doing simultaneous task such as rename active file, choose folder where to save the renamed file and delete old version of file. "Save as" dialogue allow the first ...
- 13
0
votes
1
answer
15k
views
Powerpoint VBA combine pptx files into one
I have seen a post like this before but could not add more comments and could not implement the solution. So please do not criticize :) I basically need to open an empty pptx file and give a location ...
- 1
0
votes
1
answer
4k
views
Delete specific named TextBox in Powerpoint using VBA
I have a PowerPoint presentation which have about 105 slides. On each slide, there is a Text Box named TextBox4. I want to delete all these text boxes.
I have tried some VBA code by Google Search. ...
- 775
1
vote
0
answers
257
views
Creating a dropdown submenu in PowerPoint
I would like to know if it's possible to create a dropdown submenu in PowerPoint like the one for inserting a WordArt:
If it's possible can you share with me some documentation about this?
- 2,798
4
votes
3
answers
7k
views
How to retain corner rounding while resizing rounded rectangles, just like in Adobe Illustrator in PowerPoint?
I am using PowerPoint to create mockups of user interfaces.
It's easy if you use regular rectangles with sharp corners.
It's hard when you use rounded rectangles.
Is there a way to retain the ...
user9520
1
vote
1
answer
467
views
How do I dynamically control animations in PowerPoint 2010?
I'm playing around with PowerPoint creating a trivia game. When the user clicks on a tile on the main slide it advances to another slide with the question. When the user clicks the return button, they ...
- 117
2
votes
1
answer
1k
views
How to convert formatted text in a Powerpoint table cell to HTML
I want to convert a table in a Powerpoint slide to HTML. I know how to put in the table tags, but cannot work out how to convert formatted text inside the table cells to HTML. So, for example, how can ...
- 145
0
votes
1
answer
789
views
Powerpoint VBA References
I am writing a VBA code on Powerpoint, where I need to call and excel file for input. Programme is functioning fine, runs without error, and generates output, except for the part where Excel file is ...
- 1
-1
votes
1
answer
2k
views
Automation Error Catastrophic Failure
I am trying to use excel VBA to copy some charts to Powerpoint slides using the below codes, but it shows error "Automation Error Catastrophic Failure". I can not figure out what is the problem. I am ...
- 1
-2
votes
1
answer
164
views
how to run four macros by click one button?
i have four groups of shapes. And each group got 6 shapes, and i would like to random choose one of 6 shapes in each group. And because i got four groups, which means every time i click a button, 4 ...
- 1
4
votes
1
answer
1k
views
How do I get an event to fire when the slide changes in PowerPoint?
I already know of two supposed fixes, which I will list below, along with the reason they don't work for me.
The first is to use the SlideShowNextSlide subroutine. The problem with this is that it ...
