Tagged Questions
0
votes
2answers
25 views
Shape unknown member: invalid request. To select a shape, its view must be active
I have a PowerPoint macro that takes pictures and adds them to an open slideshow. When I try to run the macro after clicking below the list of slides on the left of the screen (which causes a solid ...
-1
votes
0answers
36 views
how to save a pdf without path in vba
I have opened a pdf file who was embedded from powerpoint presentation using the following code line:
ActivePresentation.Slides(1).Shapes(1).OLEFormat.DoVerb
So it really doesn't have a path that I ...
0
votes
0answers
25 views
Convert long binary file to pdf format using vba
I want to export the pdf embedded in powerpoint presentations. Converting the ppt file to zip file you can see what is inside the file and for images and videos the format doesn't change but I realize ...
0
votes
1answer
30 views
check if a file is saved with vba
I want to give the possibility to save a powerpoint presentation when my macro executes.
I don't want it to be mandatory so I will insert a pop up asking if they want to save it.
But one problem ...
0
votes
1answer
31 views
MS Forms ComboBox not updating in VBA during run-time
I have a combobox on a userform which is not updating, unless I put a breakpoint and step through the code, or pop a MsgBox, etc.
'MsgBox "", vbInformation
Group_Form.CrossVariable_Cbox = groupVar
...
0
votes
0answers
20 views
avoid to appear a pop up while copying files in vba
When I copy the file from a folder to a zip file, for every file it appears a pop up telling that is copying from one place to other. I have to copy a large amount of files (usually more that 300) and ...
1
vote
0answers
26 views
Using IWebBrowser2 to put Widgets in PowerPoint — Automation Error: Unspecified Error
I created a simple macro to put an HTML widget from Weather.com in to a PowerPoint slide.
It is not event-based, but ActionButtons call the ConnectWidget subroutine, when navigating to the slide. ...
2
votes
1answer
32 views
Powerpoint vba to change text gradient?
Is there anything in Powerpoint vba (2007 or 2010) that lets you set or change the gradient colors on a text object (the text itself)? All I can find are presetTextEffect settings. Thanks.
0
votes
0answers
23 views
Using vba with powerpoint photo album addin
I am trying to automate the PowerPoint Photo Album addin with vba. I am running the macro from excel, from where I want to supply the filepath, and I also need to change the album layout. Other than ...
0
votes
1answer
38 views
Updating MS Power Point linked object such as chart or Excel sheet
I have a ppt which is generated every week. I have created a vbscript for updating the linked chart.. but i couldn't find how to identify the excel sheet which i have used for creating the table in ...
1
vote
2answers
62 views
Is there a way to disable CommandBar Controls in Powerpoint VBA?
I have a PPT Add-In which may fail if a certain ViewType is not maintained.
I do not see any PPTEvent which I could trap the change and prevent it (although, if this is possible, please advise!). ...
-1
votes
0answers
27 views
How to import images from a folder on daily basis?
i would like to ask a question. I found similar answers but not so specialized to my needs.
I have a ppt file created on Powerpoint 2007. I want to build a macro that can do the following:
Import ...
1
vote
1answer
66 views
Unable to Group some shapes in Powerpoint 2010
I am having some difficulty using the .Group method on a ShapeRange.
For example, I am not able to Group a table with a textbox, nor am I able to group the slide's title shape with a textbox, etc. I ...
0
votes
1answer
110 views
Use VBA to change the internal margin and/or number format of a PowerPoint table cell
I have a VBA loop that cycles through the selected cells of a PowerPoint table to update the formatting. The following lines work great:
With ...
1
vote
1answer
115 views
When to use TextFrame or TextFrame2 in VBA
Example, in Powerpoint:
The TextFrame object:
Represents the text frame in a Shape object. Contains the text in the
text frame and the properties and methods that control the alignment
and ...
0
votes
1answer
57 views
Update PowerPoint pictures using VBA
My day to day work involves creating powerpoints for clients highlighting their campaign performance. Most of the charts have been linked to excel, which saves me a ton of time but I end up spending ...
1
vote
0answers
82 views
Rendering simple html code in Powerpoint text box
I have this string of html code and I want to display it in a Powerpoint Text box properly formatted as per the HTML code using VBA.
Any suggestion on how I do that?
I inserted some spaces in the ...
1
vote
2answers
102 views
Shape.Height and Shape.Width problems in PowerPoint 2013
I am using a small VBA script to apply some text in the background. The script works fine on PowerPoint 2007 and PowerPoint 2010.
However, in PowerPoint 2013, setting Shape.Height and Shape.Width ...
1
vote
1answer
37 views
Falling Mapple Leaves PowerPoint
I want to show falling mapple leaves on a slide of ppt. Its that achievable ? If yes how ?
I did try to google but not able to figure out.
Thanks for looking into it.
1
vote
0answers
66 views
VBA Power Point Link with excel Updates
I am very new with VBA, i have the power point file to excel - Pivot table and making a macro to that it keep change the povit valuse update the ppt link and save as new name. Actually it is all ...
0
votes
1answer
105 views
How do I export text from only certain shapes in ppt using VBA?
I'm trying to export text from a large ppt. I have figured out how to export but I get all text from all shapes and I'm only interested in certain text.
Is there a way to have an IF function that ...
7
votes
4answers
156 views
VBA to Prevent Keyboard Input While a Package Object (XML) is Read into ADODB Stream?
I am developing an application which opens and reads an XML document previously embedded in a PowerPoint presentation, or a Word document. In order to read this object (xmlFile as Object) I have to ...
0
votes
1answer
168 views
Interactive Quiz using ppt
I posted a rubbish question about this before and have gone away and done some work on it to re-ask. Basically I've made a ppt quiz that counts how many correct and incorrect answers a person has ...
1
vote
0answers
60 views
use vba code in visual studio ribbon item
I have been couple of days developing some code in vba to detect different types of shapes, create and zip files and so on... The problem is that now I have to create a ribbon item in visual studio ...
0
votes
1answer
230 views
VBA Error 438 - trying to copy Excel charts to existing Ppt presentation
I'm trying to copy charts from Excel to an existing Powerpoint Template using VBA. This code returns Error 438 - Object doesn't support this property or method:
'Create a new Powerpoint session
...
2
votes
2answers
83 views
Powerpoint Event handling - Prevent New Presentation
I am creating a Powerpoint Add-in. I would like to restrict user from either:
Create New Presentation
Open an existing Presentation
I have used this tutorial/overview to trap the NewPresentation ...
0
votes
2answers
46 views
VBA POWERPOINT: Shrink Word pictures from powerpoint
This function works when I use it within a word macro to shrink all images to 9.3cm:
Sub ShrinkWordImages()
Dim iShp As InlineShape
For Each iShp In ActiveDocument.InlineShapes
...
0
votes
2answers
117 views
get format of image and videos in visual basic
I have some images and videos in my powerpoint presentation. Depends of what format have each one (jpg, mp3, jpeg,...) I want it to make a different thing so I need to know what kind of file is it. Is ...
2
votes
2answers
221 views
VBA WORD: Remove SHIFT-ENTER lines
After copying from ppt, you often get lines that look like this:
This is a line
and then another line
and then another
and so forth. New lines created
via SHIFT-ENTER.
Where I need it to say:
...
0
votes
1answer
118 views
VBA POWERPOINT: Copy text with formatting from powerpoint to word
Right now I'm copying text into word like so:
wrdDoc.Range.InsertAfter someShapeWithText.TextFrame.TextRange.Text & vbCr & vbCr
I want it to copy with formatting i.e. certain words are ...
