powerpoint-vba

Using VBA to Copy special symbols from one PowerPoint presentation to another

I need to copy text from one PowerPoint presentation to another. However, I have problems copying special symbols, such as smileys, which appear in the target presentation as empty boxes. Looking at the Open XML file in the original presentation, I can see that the Run containing the smiley has a "SymbolFont" attribute: < a:sym typeface...

Run VBA on any PowerPoint to change the LanguageID

I'm trying to create a toolbar with a button that will change the LanguageID for all shapes and text boxes in a PowerPoint document to EnglishUS. This is to fix a problem where if someone spell-checks a document using another language (in this instance, French), that language is embedded into the .ppt file itself. When another user tries...

Mac Office 2008 Development- AppleScript vs. VBA

I'm looking for some advice from anyone who has experience writing addons for PowerPoint on both Windows and Mac machines. We have a Windows Office 2007 addon (.NET) that we'd like to port to the Mac. Thus, in PowerPoint 2008 for the Mac, we require the following functionality: Ribbon/Fluent extensibility Custom Task Panes Re...

PickUp/Apply Paragraph Formatting in PowerPoint 2007

In PowerPoint 2007, PickUp/Apply does not capture some paragraph formatting, such as bullet formatting, when used programmatically (VBA). Adding the PickUp and Apply buttons to the Quick Access Toolbar (QAT) and trying this manually confirms this. However, if you triple-click on a bulleted paragraph and select PickUp from the QAT, then...

Get Layout Shape Corresponding to Slide Shape

In PowerPoint 2007 and using VBA, how can I get the placeholder shape on a Slide Master layout that is the "master" for a placeholder shape on the slide? I am currently using a loop to compare the position and size of the slide placeholder with the position and shape of each placeholder shape in the slide's layout, but this isn't fool-p...

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 how to mimic this behavior? Is it a standard functionality or requires some VBA code? If so how to get this effect. ...

VBA save Presentation as PDF in Handout 2x2 format Office 2007

I'm trying to save a PowerPoint presentation using VBA, and I want to save it as a .pdf in Handout format with 2x2 slides on a page. Can somebody tell me or point me to a link that tells me how to do it. I've done my homework on Google, but couldn't find it. Any help/suggestions/hints will be appreciated. I've tried searching the refere...

How To Make Selected Columns the Same Width in a PowerPoint Table?

Is there a way to programmatically make only some columns in a PowerPoint table the same width? It should be their combinded width, divided by the number of columns, but I can't figure out a way to do this. ...

How can I write XML from PowerPoint VBA?

Hello! I have another question. I need to develop a PowerPoint add-in (for 2003 and 2007 versions) that will be installed on some users computers. It needs to track some of the things they do when they give presentations and then send me the results. These will be on people's computers that are not under adminstration control (e.g. vendo...

How to pass PowerPoint words from slides to a txt with vba?

Is there a way to extract the words from the slides (titles and the rest) of a PowerPoint deck and write them to a txt file using VBA? ...

Naming Slide Images on Export in PowerPoint 2007

Presentation.Export(filename, "PNG", sizeX, sizeY); creates thumbnail images of all slides in the PowerPoint presentation. My problem is that the thumbnail filenames change according to the Language of PowerPoint. On an English PowerPoint, the thumbnail files are: "slide1.png", "slide2.png", etc. On Hebrew PowerPoint: שקופית1.png, שקו...

How to make a progress bar in powerpoint vba?

How can I make a progress bar with PowerPoint VBA? It should be done as an animation on a slide. ...

How to create a Sub in VBA that is executed when its correspondent Add-In is loaded?

I have a subroutine in VBA that is executed when we open a PowerPoint presentation but I want to execute that Sub when an Add-in is loaded instead. How can I do that? ...

How to make a toolbar button with caption below icon using VBA?

What's missing in the following code, for the .Caption gets bellow and the icon on the top? Sub SoundLogToolbar() Dim cb As CommandBar Dim de As CommandBar Dim but As CommandBarButton Dim picPicture As IPictureDisp On Error Resume Next MkDir "C:\SoundLog\" On Error GoTo 0 On Error Resume Next ...

Is there a way to use Unicode paths/filenames in Word 2003 or higher VBA code?

Is there a way to use Unicode paths/filenames in Word 2003 or higher VBA code? It appears that Word supports Unicode path/filenames via its interactive dialogues, but when our VBA code tries to manipulate Unicode path/filenames exposed via Word properties, we get back strings with lots of question marks. Is there something we need to d...

Programmatically Setting Text Shadow Properties in PowerPoint

PowerPoint has two kinds of shadows - shape and text. Shape shadows may be set by right-clicking on a shape (including a text box), choosing Format Text, then selecting Shadow or using VBA via the Shadow property on each shape: For Each Slide In ActivePresentation.Slides For Each Shape In Slide.Shapes Shape.Shadow.Size = 100 ...

How to reference an embedded PowerPoint or Excel file in a form in Access?

So if I was to take a an Access form, and embed either an Excel spreadsheet into it or a PowerPoint deck, how would I reference it in VBA code? I know I have to set the libraries, name the frame of the OLE object, and use applicable syntax to whatever I want to do, with whatever I stick in the form, however the only things I have ever d...

Reading PowerPoint Animation Effects with VBA

I have been working with PowerPoint VBA, and have a grasp on most things. What I am struggling with is reading the effect/animation settings for each object. I seem to be able to get a lot of what I need through the Powerpoint.ActivePresentation.Slides(slide_id).TimeLine.MainSequence(seq_num) What confuses me is how to convert the num...

How do you "ungroup" an image in PowerPoint using VBA

I have a PowerPoint file with a slide with an image (wmf/emp file) in it and I want to "ungroup" the image elements in it using VBA. I need to ask PowerPoint twice to do it - but then it does. Can it be done using VBA? and if so, how? ...

How to create a PowerPoint timer?

I have to complete a timer in PowerPoint, it counts down for a specificed amount of time when a shape on particular slide is clicked. I heard macros could be a way to do this, but I have very little knowledge about them. With my research I was able to add a macro and pop out a message box when a shape is clicked. How can I implement a ...