|
How to extract text
from SmartArt...
|
A routine to work around limitations
in extracting text and hyperlink info from smartart using vba
Required: PowerPoint 2007 or
later
|
How to determine the
cursor position in slide sorter view...
|
A simple workaround to arrive at the
cursor position even if no slides are selected in the slide
sorter view.
Required: PowerPoint 97 or
later
|
Timeline – The
animation engine in PowerPoint 2002/2003 - Part I
|
Introduction to the Timeline object
and more about animation information in PowerPoint 2002/2003
Required: PowerPoint 2002 or
later
|
VBA newbie
|
A section for the PowerPoint
VBA newbie. Contains commonly requested routines by a beginner
to PowerPoint VBA
Required: PowerPoint 97 or
later
|
How to activate the
outline/thumbnails tab
|
Set either outline/slides tabs as the
active tab in the normal view, something which is not possible
using the object model directly.
Required: PowerPoint 2002 or
later
|
Add items to the '
Presentation' task pane
|
Learn how to add items to the
Presentation task pane programmatically or thru registry hacks
Required: PowerPoint 2002 or
later
|
Enumerate Hyperlinks
in a presentation and associated objects
|
List out all hyperlinks in the
presentation and learn more about how to use the useful Parent
property.
Required: PowerPoint 97 or
later
|
Inter-presentation
communication
|
Two techniques to exchange variable
values between two independent presentation.
Required: PowerPoint 97 or
later
|
Extract Slide
selection as Presentation
|
Select slides in the active
presentation and create a presentation from this
selection.
Required: PowerPoint 97 or
later
|
Assign
interactive animation
|
Code which illustrates how to assign
an animation to a shape and have it triggered by clicking
another shape.
Required: PowerPoint 2002 or later
|
Ascertain if a shape
is animated
|
Code which illustrates how to assign
an animation to a shape and have it triggered by clicking
another shape.
Required: PowerPoint 2002 or later
|
Set table border
colour
|
Create a wrapper to format borders
for a PowerPoint table Required: PowerPoint 2000 or
later
|
Delete empty autoshapes/textboxes
|
A clean up routine to delete shapes
with no fill, no border and no text. Required:
PowerPoint 97 or later
|
Find and Recolor
|
Learn how find and replace one color
with another on fills, text and borders
Required: PowerPoint 97 or
later
|
How to apply designs
to various slides (2002+)
|
Learn how to assign a design other
than the default in PowerPoint XP using the Design property
Required: PowerPoint 2002 or
later
|
Locate specific text
and format the shape containing it
|
Search for text in shapes and
apply customized formatting to shapes containing the
specified text.
Required: PowerPoint 97 or
later
|
Locate and highlight
instances of a specific word
|
Locate the keyword and highlight each
instance with desired formatting.
Required: PowerPoint 97 or
later
|
Export Slides within
a Presentation as files
|
Split up slides in a presentation
into individual files while still retaining it's formatting.
Required: PowerPoint 97 or
later
|
Create a
presentation of slide images
|
Make use of the slide thumbnail
available in the notes page to paste slide images into a
presentation.
Required: PowerPoint 97 or
later
|
Roll Over
Demonstration
|
Sample demonstration to simulate a
rollover effect in PowerPoint.
Required: PowerPoint 97 or
later
|
Break OLE
links programmatically
|
Workaround the in-availability of
a break links method in the Object model for linked files.
Required: PowerPoint 97 or
later
|
How to extract
images from a presentation
|
Routine which extracts all images
from a presentation at original resolutions.
Required: PowerPoint 97 or
later
|
Copy slides with
source formatting
|
Copy slides while still retaining the
source design.
Required: PowerPoint 2002 or
later
|
Manipulating Tables in PowerPoint
More
manipulation of Tables in PowerPoint ...
|
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 PowerPoint version 2000 and above.
Required: PowerPoint 97 or
later
|
Multiple templates in
PowerPoint 2002/XP
|
A look at the Designs object in
PowerPoint XP which introduces support for multiple design
templates.
Required: PowerPoint 2002 or
later
|
The PowerPoint Add-in
FAQ
|
Comprehensive collection of most
commonly asked questions related to the PowerPoint add-ins.
|
Toggle images on every
click on the shape
|
Code which toggles a given pair
of images every time it is clicked during the slide show.
Required: PowerPoint 97 or
later
|
Automate PowerPoint
and insert an image on the slide
|
Code to insert an image onto a
slide and scale it to it's original size.
Required: PowerPoint 97 or
later
|
What is a Bounding Box
in a shape's text range?
|
A brief explanation of what the
bounding box associated with the text range object is!!
Required: PowerPoint 97 or
later
|
Create an agenda
slide with hyperlinks to the slides
|
Generate an agenda slide quickly
with hyperlinks to the component slides of the presentation.
Required: PowerPoint 97 or
later
|
Programmatically
restore an image to it's original state
|
Restore the default state
(original size, brightness, contrast etc) of an image shape
imported into the slide.
Required: PowerPoint 97 or
later
|
Generic function to
obtain the current slide object in any view
|
A generic function which accepts
the active window and returns the active slide object in
that window.
Required: PowerPoint 97 or
later
|
How to activate a
graph object in a separate window
|
Graph object always opens up
within PowerPoint. Lean how to programmatically open the
object in a separate window.
Required: PowerPoint 97 or
later
|
How to display
in-built 'Open/Save As' dialogs in PowerPoint
|
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
|
Offset the data labels
of a graph object on a slide
|
Manipulate data labels of a graph
object using code
Required: PowerPoint 97 or
later
|
How to determine the
current cursor position in Slide View
|
Locate the where the cursor is
located currently, the area of selection etc
Required: PowerPoint 97 or
later
|
Reference an ActiveX
control on a slide in VBA
|
Learn how to get a reference to
the activex control placed on a slide
Required: PowerPoint 97 or
later
|
Get a reference to
the Title shape on a slide
|
Multiple ways in which one can
get a reference to the title shape on the slide.
Required: PowerPoint 97 or
later
|
How to
programmatically pause a show.
|
Pause a show, this works even in
kiosk mode of a show which otherwise does not provide any
way of pausing a show.
Required: PowerPoint 97 or
later
|
Print the current
slide in a show
|
How to print the current slide
being displayed in the show
Required: PowerPoint 97 or
later
|
How to determine
which shape was clicked
|
A quick method to ascertain which
shape was clicked by the user.
Required: PowerPoint 97 or
later
|
How to update
information within unrelated excel objects inserted in slides of a
presentation
|
Makes use of the events supported
by Excel to update values across various Excel objects in
the presentation
Required: PowerPoint 97 or
later
|
Two methods to play
sound files (*.WAV) files synchronously/asynchronously
|
Make use of two API calls to get
the desired effect.
Required: Word, PowerPoint,
Excel ( 97 or later)
|
Global Find And
Replace routine in PowerPoint
|
Learn to correctly implement the
Replace method in PowerPoint
Required: PowerPoint 97 or
later
|
Power Point VBA
Equivalent of Application.ScreenUpdating method
|
Learn how to prevent the Main
PowerPoint Window from redrawing while performing screen
intensive routines.
Required: PowerPoint 97 or
later
|
How to open
a PowerPoint Show (*.pps) file programatically
|
Workaround the default behaviour
of Presentation.Open method to open the *.pps files in Slide
Show mode.
Required: PowerPoint 97 or
later
|
Paste Excel chart as
pictures in PowerPoint (Paste Special)
|
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)
|
Clear all the
animations
|
Helper routine to wipeout all the
custom animations set in the presentation
Required: PowerPoint 97 or
later
|
Exporting All
Slide Titles To A Text File
|
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.
Required: PowerPoint 97 or
later
|
Restore the Insert
Word Table button on the Standard toolbar (PPT 2000)
|
One line routine to create the
original Insert Word Table button on the PowerPoint toolbar
Required: PowerPoint 97 or
later
|
Simulate a countdown
timer using Sleep API
|
Show a countdown on a slide.
Example of using the Sleep API
Required: PowerPoint 97 or
later
|
Using
SetTimer-KillTimer API in PowerPoint 2000
|
Learn to make use of the
AddressOf keyword introduced in Office 2000 to create a
Timer in PowerPoint.
Required: PowerPoint 2000
or later
|
Disable the "Update
links" dialog box
|
Prevent the Links Update box from
appearing every time you open a presentation with links.
Required: PowerPoint 97 or
later
|
Quiz in PowerPoint
using VBA
|
Make use of the inherent features
of VBA to create a quiz very quickly.
Required: PowerPoint 97 or
later
|
Use CreateObject to
Print Slides From A Presentation
|
Example of using the CreateObject
Function to print slides .
Required: PowerPoint 97 or
later
|
|