powerpoint-vba

Editing Embedded PowerPoint from Excel VBA

I have an embedded PowerPoint presentation in an Excel workbook. How can I edit this (open, copy slides, add data to slides, close) using VBA? ...

VBA in PowerPoint

Could anyone recommend me a good online guide to PowerPoint VBA? Else, does anyone has advice on how to record a macro in PowerPoint? Thanks! ...

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! ...

Export from PowerPoint to animated gif?

Is it possible to export a picture with custom animation from PowerPoint to an animated gif? ...

Defining macros in Power Point 2007?

It USED to be the case in Office 2003 that you could find "macros" and -- IIRC -- you had a "record macro" option. But, in PowerPoint 2007, under View->Macros, you get a macro box. None of the options are "record". If you put in a name, you can select "create", but that takes you to the VB editor. If you edit the slide manually, it does...

VBA & PowerPoint

How do I rename a slide in VBA? Need help on a sample scenario: I have a slide and have a command button on it. When clicked, it should pop up a window/ image and when clicked again should dispose the window. We can do it. When copied into another deck, I cannot use the default slide name from deck 1. how can we make a slide with VBA ...

Reading Formatted Text from PowerPoint Programatically

I use something like this to get the text from a shape inside PowerPoint: s = ActiveWindow.Selection.SlideRange.Shapes("rec1").TextFrame.TextRange.Text However, if the text has bold, underlined, resized (etc) text within the shape (meaning only certain words or phrases inside the shape), the .Text property converts it all to plain tex...

Legacy VBA Solutions are not working in Office 2007

Folks, An existing system that was based on VBA was installed on a machine that has Office 2007 and it didn't work, the issues I faced are : A PowerPoint Add-in (.PPA) is no longer able to create the custom buttons in the shortcut menu, did Office 2007 change the commandbar names ? The MSI (written in Wix) didn't install the files in ...

PowerPoint Automation from MS Access....queries to chart?

Hey guys! I am wondering if there is anyone out there that can help me with this... I have an Access db that I use to track metrics where I work and "number crunch" for data that I use to build ppt presentations. I have to usually do about 40 ppt's per month, and they are 98% charts. Right now, I run queries one at a time (using SQL st...

Export Embedded Excel Workbook in a PowerPoint slide to Excel

I have a PowerPoint presentation w/ an embedded Excel Workbook, name: ThisWorkbook I need to export ThisWorkbook into an Excel File. Thank you ...

Embedding PowerPoint Chart into Excel

Hey guys! I always get great answers here, so here is another question (this one may be simple, but I don't know if/how...). If I embed a PowerPoint Presentation within an Excel Worksheet, then, within the ppt, set up chart objects on each slide, can I go into the data table for the chart object, and have it refer back to the excel spre...

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 figure out how to apply bold, italic and underline programatically (I don't see a .RichText property or something similar). What I have is...

VBA for Inserting a chart into a ppt slide

Below is a procedure that I use to pull charts into a ppt from excel spreadsheets. However one thing I cannot figure out is how to insert the picture into the "object" instead of just pasting it onto th screen. (ie if I did a ppLayoutFourObjects, and sent fours charts to this slide, before adding another, I need to know how to paste the ...

Creating a Powerpoint with Graphs from Access

I am trying to programmatically create a PowerPoint from graphs in Access. Ideally, when the graphs move over to PowerPoint they will become static pictures and not graphs still linked to the access data. I have tried procedures such as: Private Sub Command1_click() Dim pwrpnt as Object Dim Presentation as Object set p...

Anyone know of a website for learning VBA in PowerPoint?

I can do a few things with powerpoint, but I need to learn more about the basics: -adding a new textframe and text, and placing it where I want to on the slide -how to use VB to control the master slide -add text to the notes field stuff like that. my experience with vb and ppt has been some automation stuff from access, but ppt is one...

PowerPoint 2003 - VBA for entering information into the Notes section?

I am trying to find out how you write VBA to enter a text box into a slide, and enter text. I am also trying to find vba for entering text into the notes section of a PowerPoint slide. Any help would be greatly appreciated. I have tried to find a site specifically for this, but have not been able to do so ...

Visual Basic _ Question about findings the right study material?

Hey does anyone know of a great book/CD-ROM, etc for learn some novice to advanced Visual Basic study. I think I have about graduated the beginner stage. The main thing I need to do with Visual Basic is use it in conjunction with Office applications (2003 to be precise). Mostly MS Access, Excel and PowerPoint. But I want to learn more, I...

Create own powerpoint animation in VB

How can I create my own PowerPoint animations in VB? Not sure where I can find the right commands etc.. I am somewhat familiar with VB... Is it even possible to achieve what I am looking for? ...

VBA for altering PowerPoint 2003 Presentations- Active not new

If I set up a template on PowerPoint slides, that contain all the text boxes I need, the what Visual Basic do I use to enter text that I want into those text boxes? It is easier for me to use a template, because these ppt briefs contain (or need to contain) a lot of data: how do I enter text into those text boxes how do you alter the ...

PowerPoint - load macro on document load?

Does anyone know how I can have a macro load on document load when opening a PowerPoint pot-template? I've looked at some Auto_Open and add-ins which looks like need to be set. But there's a few settings that need to be set as well within PowerPoint itself for it to work. I've got a template which thousands of users are about to be usin...