![Programming PowerPoint With VBA Straight to the Point](https://img.perlego.com/book-covers/3259245/9781615471638_300_450.webp)
eBook - ePub
Programming PowerPoint With VBA Straight to the Point
Eduardo N Sanchez
This is a test
- 57 pages
- English
- ePUB (adapté aux mobiles)
- Disponible sur iOS et Android
eBook - ePub
Programming PowerPoint With VBA Straight to the Point
Eduardo N Sanchez
DĂ©tails du livre
Aperçu du livre
Table des matiĂšres
Citations
Ă propos de ce livre
This book assumes you already use PowerPoint and want to automate or enhance your presentations using Visual Basic for Applications (VBA). This book includes VBA samples for working with layouts, themes & masters, creating tables, drawing objects, charting, animation effects and event programming. It also includes a chapter for interfacing between PowerPoint and Word, Excel, Access or Outlook.
Foire aux questions
Comment puis-je résilier mon abonnement ?
Il vous suffit de vous rendre dans la section compte dans paramĂštres et de cliquer sur « RĂ©silier lâabonnement ». Câest aussi simple que cela ! Une fois que vous aurez rĂ©siliĂ© votre abonnement, il restera actif pour le reste de la pĂ©riode pour laquelle vous avez payĂ©. DĂ©couvrez-en plus ici.
Puis-je / comment puis-je télécharger des livres ?
Pour le moment, tous nos livres en format ePub adaptĂ©s aux mobiles peuvent ĂȘtre tĂ©lĂ©chargĂ©s via lâapplication. La plupart de nos PDF sont Ă©galement disponibles en tĂ©lĂ©chargement et les autres seront tĂ©lĂ©chargeables trĂšs prochainement. DĂ©couvrez-en plus ici.
Quelle est la différence entre les formules tarifaires ?
Les deux abonnements vous donnent un accĂšs complet Ă la bibliothĂšque et Ă toutes les fonctionnalitĂ©s de Perlego. Les seules diffĂ©rences sont les tarifs ainsi que la pĂ©riode dâabonnement : avec lâabonnement annuel, vous Ă©conomiserez environ 30 % par rapport Ă 12 mois dâabonnement mensuel.
Quâest-ce que Perlego ?
Nous sommes un service dâabonnement Ă des ouvrages universitaires en ligne, oĂč vous pouvez accĂ©der Ă toute une bibliothĂšque pour un prix infĂ©rieur Ă celui dâun seul livre par mois. Avec plus dâun million de livres sur plus de 1 000 sujets, nous avons ce quâil vous faut ! DĂ©couvrez-en plus ici.
Prenez-vous en charge la synthÚse vocale ?
Recherchez le symbole Ăcouter sur votre prochain livre pour voir si vous pouvez lâĂ©couter. Lâoutil Ăcouter lit le texte Ă haute voix pour vous, en surlignant le passage qui est en cours de lecture. Vous pouvez le mettre sur pause, lâaccĂ©lĂ©rer ou le ralentir. DĂ©couvrez-en plus ici.
Est-ce que Programming PowerPoint With VBA Straight to the Point est un PDF/ePUB en ligne ?
Oui, vous pouvez accĂ©der Ă Programming PowerPoint With VBA Straight to the Point par Eduardo N Sanchez en format PDF et/ou ePUB ainsi quâĂ dâautres livres populaires dans Informatica et Applicazioni desktop. Nous disposons de plus dâun million dâouvrages Ă dĂ©couvrir dans notre catalogue.
Informations
1 Basic Operations
Introduction
There is a joke saying that PowerPoint is a free application that comes along when you buy ExcelâŠ
Actually, PowerPoint is a complex program that offers everything you need to create and manage professionally built presentations.
This book assumes you are already a PowerPoint user who wants to automate and enhance your presentations using Visual Basic for Applications, which is currently the Office programming language. It is also a pre-requisite that you have basic knowledge on how VBA works, as we do not have room here to teach it from the ground up.
We will review some concepts, but the main goal of this book will be to show how VBA can make PowerPoint even better. Welcome aboard!
Creating a simple presentation
Our first example is quite straightforward: the code generates a new presentation with six slides, each one containing a title and a bulleted list. The picture below shows the final result. Observe that the chosen layout contains two shapes; the first one will hold the slide title whereas the second will be used for the list.
Sub AddSlides()
Dim Pre As Presentation, sld As Slide, i%, j%
Set Pre = Presentations.Add(msoTrue)
j = 1
For i = 1 To 6
Set sld = Pre.Slides.Add(Index:=Pre.Slides.Count + 1, Layout:=ppLayoutText)
sld.Shapes(1).TextFrame.TextRange = "Title of Slide " &i
sld.Shapes(2).TextFrame.TextRange = "Line " &CStr(j) &vbNewLine& _
"Line " &CStr(j + 1) &vbNewLine& "Line " &CStr(j + 2) &vbNewLine
j = j + 3
Next
End Sub
![](https://book-extracts.perlego.com/3259245/images/Image35847-plgo-compressed.webp)
This presentation was created with VBA
Where is the macro recorder?
Excel programmers know of this handy tool that records actions and generates the corresponding code. It often requires adjustments, but will give you the necessary properties and methods for that particular task. For example, if you format some text with the recorder turned on, it will give you VBA code that you can play back to do the same job again.
Unfortunately, since PowerPoint 2007 Microsoft removed this functionality from the program.
Excel programmers know of this handy tool that records actions and generates the corresponding code. It often requires adjustments, but will give you the necessary properties and methods for that particular task. For example, if you format some text with the recorder turned on, it will give you VBA code that you can play back to do the same job again.
Unfortunately, since PowerPoint 2007 Microsoft removed this functionality from the program.
Object Browser and Intellisense
Two features that will help finding needed properties and methods are the object browser window and the so called Intellisense menu.
To activate the object browser view, just press the F2 key when in the VB editor; you will see something similar to the image beneath. It can be used to browse the object tree and search for the available elements. To return to the code window, press F7.
![](https://book-extracts.perlego.com/3259245/images/Image35855-plgo-compressed.webp)
Choose a class to see a list of its members
Another useful feature is the dropdown menu that appears when you type a period after an object in the VB editor. It will list most of the valid properties and methods you can use with that specific object. To make sure this option is active, go to Tools > Options and confirm that auto list members is checked.
![](https://book-extracts.perlego.com/3259245/images/Image35863-plgo-compressed.webp)
The dropdown displays a list of options.
Saving as PDF
It is simple to save a presentat...