Vba Powerpoint Activate Presentation

Make your VBA code in PowerPoint respond to events. PowerPoint 97 doesn t support events, so it can t automatically run macros when a presentation opens, at print.

Manipulate hidden Dialog object to display the common dialogs. Officially Dialogs are a part of the PowerPoint object model. We make use of some undocumented stuff to make it work.

Required:  PowerPoint 97, 2000 only

Manipulate data labels of a graph object using code

Required:  PowerPoint 97 or later

Locate the where the cursor is located currently, the area of selection etc

Learn how to get a reference to the activex control placed on a slide

Multiple ways in which one can get a reference to the title shape on the slide.

Pause a show, this works even in kiosk mode of a show which otherwise does not provide any way of pausing a show.

How to print the current slide being displayed in the show

A quick method to ascertain which shape was clicked by the user.

Makes use of the events supported by Excel to update values across various Excel objects in the presentation

Make use of two API calls to get the desired effect.

Required:  Word, PowerPoint, Excel 97 or later

Learn to correctly implement the Replace method in PowerPoint

Learn how to prevent the Main PowerPoint Window from redrawing while performing screen intensive routines.

Workaround the default behaviour of Presentation.Open method to open the . pps files in Slide Show mode.

Workaround the absence of Paste Special method. The routine explains how to make use of the Excel CopyPicture method to paste charts as pictures.

Required:  PowerPoint / Excel 97 or later

Helper routine to wipeout all the custom animations set in the presentation

Helper routine to export titles of all the slides in the presentation to a text file. Will shortly be  to copy the titles to clipboard too.

One line routine to create the original Insert Word Table button on the PowerPoint toolbar

Show a countdown on a slide. Example of using the Sleep API

Learn to make use of the AddressOf keyword introduced in Office 2000 to create a Timer in PowerPoint.

Required:  PowerPoint 2000 or later

Prevent the Links Update box from appearing every time you open a presentation with links.

Make use of the inherent features of VBA to create a quiz very quickly.

Example of using the CreateObject Function to print slides.

Required:  PowerPoint 97 or later.

This blog post will show you exactly how you can copy and paste an Excel range into a brand new PowerPoint presentation with a VBA coded macro.

ActiveWindow.Selection.Copy

ActiveWindow.View.Paste

I will figure it out if I could just find the way to activate an open presentation other than the on that is activated.

So e.g. if pptpres is activated I could copy the active slide and then activate pptpres2 and paste it until all done.

I thought the code would be pptpres.Activate name of presentation but no luck.

Also any could books on ppt vba out there. I can t find a one.

Thanks much Leon.:banghead:

TrippyTom

06-28-2007, AM

Part of the problem is PowerPoint itself. The VBA Object model for PowerPoint is TERRIBLE. It s the worst out of the whole suite of applications and Microsoft should be whipped repeatedly with a wet noodle for making it so user UNfriendly.

Anyway, I had a similar need in the past, and what I ended up doing was creating the slide layout through code. I tried your way first, but it was proving to be just too unreliable.

So here s a link to the topic I posted my sample code in:

12800

Thanks very much for your response TrippyTom.

I was trying to keep the question simple but realize now I need to go into more detail.

I am limited to office 2003 and xp.

Also, those 3 other presentations with 10 slides are made of images of charts pasted from excel into one ppt presentatoin. I manipulated ppt from excel.

I am not the best programmer and this method is the only way I could figure out how to do it and I am about 5 days into creating that part.

So I very much just want to put the slides from one file into the other file and order them. I didn t mention that part yet but am thinking I can figure out how to order them by the slide name.

I appreciate your method but am afraid I would then have to recreate getting the graphs from excel into ppt. 5 days worth of time. I am not very good at navigating the slides to land the right graph on the right slide also.

So much of the ppt code I see always uses the activepresentation method of id ing. At this point I really just want to know how to activate a presentation and then activate the other open presentationback and forth. Still very grateful for your time. Thank, Leon

Norie

07-01-2007, AM

Leon

I ve not coded much with Powerpoint VBA but when I looked at the code in Tom s link I see that he doesn t actually appear to be activating anything.

In Excel, which I normally code in, it s generally not needed to activate/select anything eg worksheets to work with them.

Perhaps that s the same in PowerPoint.

I ve just done a small test.

Sub test.

Learn how to insert MS word tables into a slide and how to manipulate the native PowerPoint table shape. The native table shape is supported only with.

I am writing a small excel add-in for some simple data analytics but unfortunately i am not a VBA-programmer ; what i have done up to now: fetch data from a huge.

I m attempting to take the value in Excel cells and value PowerPoint text boxes. I don t want to link a PowerPoint table to an Excel spreadsheet because the.

Wondering if there is a way to actually use excel slicers while in PowerPoint Presentation mode. I figured out how to incorporate the slicers into the PPT but when.