Home | VBA Section | General Section | Downloads | Licensing | Privacy Policy

Office VBA

Add-ins
FaceID Browser
Peruse thru all Office menu icons

 

Generic class wrapper which reads the UserInfo key in the registry

Read registry values which are not accessible natively.

Version supported: Excel, PowerPoint Word (97 & 2000)

 

    How to clear the Clipboard in Office 2000

    A suggested workaround to deal  with unavailability of a direct method to clear the multiple clippings supported by Office 2000

    Version supported: Excel, PowerPoint, Word ( 2000)

     

     

    How to set two toolbars on the same row

    How to make toolbars share the same row in their docked states.

    Version supported: Excel, PowerPoint, Word (97 or later)

     

     

    How to determine the which Command Bar button was clicked

    How to ascertain which was the button responsible for the procedure being invoked.

    Version supported: Excel, PowerPoint, Word (97 or later)

     

     

     


    PowerPoint VBA


     
    Add-ins
     Image Importer Wizard
     Import tons of images in a jiffy
     
    Secure Pack
    Distribute Secure Presentations
     
    Shyam's Toolbox
    Increase your productivity
     
    Handout Wizard
    Create customized handouts
     
    Animation Carbon
    Copy, store, distribute animations
     
    More downloads

     

    How to determine the cursor position in slide sorter view... New

    A simple workaround to arrive at the cursor position even if no slides are selected in the slide sorter view.

    Version supported: 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

    Version supported: PowerPoint 2002 or later

     

    VBA Newbie

    A new section for the PowerPoint VBA newbie. Contains commonly requested routines by a beginner to PowerPoint VBA

    Version supported: 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.

    Version supported: PowerPoint 2002 or later

     

    Add items to the 'New Presentation' task pane

    Learn how to add items to the New Presentation task pane programmatically or thru registry hacks

    Version supported: 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.

    Version supported: PowerPoint 97 or later

     

    Inter-presentation communication

    Two techniques to exchange variable values between two independent presentation.

    Version supported: PowerPoint 97 or later


     

    Extract Slide selection as Presentation

    Select slides in the active presentation and create a new presentation from this selection.

    Version supported: 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.
    Version supported: 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.
    Version supported: PowerPoint 2002 or later

     

    Set table border colour

    Create a wrapper to format borders for a PowerPoint table
    Version supported: PowerPoint 2000 or later


    Delete empty autoshapes/textboxes

    A clean up routine to delete shapes with no fill, no border and no text.
    Version supported: PowerPoint 97 or later


    Find and Recolor

    Learn how find and replace one color with another on fills, text and borders

    Version supported: 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

    Version supported: 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.

    Version supported: PowerPoint 97 or later

     

    Locate and highlight instances of a specific word

    Locate the keyword and highlight each instance with desired formatting.

    Version supported: 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.

    Version supported: 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 new presentation.

    Version supported: PowerPoint 97 or later


    Roll Over Demonstration

    Sample demonstration to simulate a rollover effect in PowerPoint.

    Version supported: PowerPoint 97 or later



    Break OLE links programmatically

    Workaround the in-availability of a break links method in the Object model for linked files.

    Version supported: PowerPoint 97 or later



    How to extract images from a presentation
     

    Routine which extracts all images from a presentation at original resolutions.

    Version supported: PowerPoint 97 or later


     

    Copy slides with source formatting

    Copy slides while still retaining the source design.

    Version supported: 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 new native PowerPoint table shape. The native table shape is supported only with PowerPoint version 2000 and above.

    Version supported: PowerPoint 97 or later

     

    Multiple templates in PowerPoint 2002/XP

    A look at the new Designs object in PowerPoint XP which introduces support for multiple design templates.

    Version supported: 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.

    Version supported: 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.

    Version supported: 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!!

    Version supported: 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.

    Version supported: 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.

    Version supported: 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.

    Version supported: 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.

    Version supported: 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.

    Version supported: PowerPoint 97, 2000 only

     

    Offset the data labels of a graph object on a slide

    Manipulate data labels of a graph object using code

    Version supported: 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

    Version supported: 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

    Version supported: 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.

    Version supported: 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.

    Version supported: PowerPoint 97 or later 

     

    Print the current slide in a show 

    How to print the current slide being displayed in the show

    Version supported: PowerPoint 97 or later 

     

    How to determine which shape was clicked

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

    Version supported: 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

    Version supported: 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.

    Version supported: Word, PowerPoint, Excel ( 97 or later)

       

    Global Find And Replace routine in PowerPoint

    Learn to correctly implement the Replace method in PowerPoint

    Version supported: PowerPoint 97 or later 

     

    Power Point VBA Equivalent of Application.ScreenUpdating method Updated

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

    Version supported: 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.

    Version supported: 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.

    Version supported: PowerPoint / Excel (97 or later)

       

    Clear all the animations

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

    Version supported: 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 updated to copy the titles to clipboard too.

    Version supported: 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

    Version supported: PowerPoint 97 or later 

     

    Simulate a countdown timer using Sleep API

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

    Version supported: 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. 

    Version supported: 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.

    Version supported: PowerPoint 97 or later 

     

    Quiz in PowerPoint using VBA

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

    Version supported: PowerPoint 97 or later 

     

    Use CreateObject to Print Slides From A Presentation

    Example of using the CreateObject Function to print slides .  

    Version supported: PowerPoint 97 or later 

     

     

     


    Excel VBA

     

    Highlight all cells containing hyperlink in a sheet

    Select all the cells, in the active worksheet, which contain hyperlinks.

    Version supported: Excel 97 or later

     

       

       

       

      Word VBA

       

      Clear all hyperlinks from a Word Document but retain the text 

      A quick way to get rid of all the blue colored hyperlinks, yet ensure that the text isn't deleted.

      Version supported: Word 97 or later

       

        Extract Embedded PowerPoint Slides from a Word Document New

        A Word macro to extract embedded slides within a document as presentations.

         

         

         

         


        Copyright © 1999-2008 Shyam Pillai. All rights reserved.