Welcome to OfficeTips, where I provide some examples of the enhanced functionality available through the VBA & Win32 API when applied to MS Word, MS PowerPoint & MS Excel. While the main focus of this site is application of VBA to extend available functionality or introduce functionality, where lacking; in the coming months you will see a lot more examples using Visual Basic 2005 and C# too.

You can now search this website for the relevant articles and downloads. Many thanks to Felix Kasza (MVP) for hosting this site. 

News: Download Office 2007 Service Pack 2 to address the issue of truncated images in handout wizard output presentation.

Commercial Add-ins

• Animation Carbon
  Copy, duplicate, manage, export, share PowerPoint 2002/2003 animations. Everything that you always wanted. Click here to download.

• Handout Wizard for PowerPoint
  Break free from the limitations imposed by PowerPoint on creation of handouts. Create your own customized layouts and more. Fed up with the file bloat of Send-To-Word option? Try a better alternative! Download it now. 

• Toolbox for PowerPoint version 2.1
  This is the compiled collection of my newsgroup code postings and other related code found on my site for the end users. Download it now. 

• Secure Pack   version 3.5  Updated

  Password protect your presentations being tampered/edited. Distribute standalone presentations. Secure Pack transforms presentations - the most common form of business communication - into non-editable valuable assets.  Click here to learn more. 

• Image Importer Wizard version 3.3 Updated
  Import tons of images into PowerPoint, fast! Customize it to your requirement. Set search parameters, image criteria, import rules, save these settings etc. Have fun. Leverage the powerful 'defined layouts' to create user specific look and feel for the images imported. 

• Batch Exporter for PowerPoint
  Fast, efficient and streamlined to export the components of a presentation in an organized manner for archival or other related purposes. Click here to download.

Free Add-ins

• YouTube Video Add-in New

• Narration Timing Tweaker

• Motion Path Tools add-in (2002+)

• Workarea add-in

• Motion Path End Position add-in  (2002+) also available in Motion Path Tools add-in

• Shape console for PowerPoint 2000 or later  (2000+)

• Music Span: add-in for PowerPoint New

• Sequential Save Add-in for PowerPoint

• Word/Phrase Search Add-in for PowerPoint

• FlashBack - rewind flash movies (SWF) during slide show.

• LiveWeb - Display web pages real-time.  Added PPT 2007 support 

• Show all...

What's New...

PowerPoint 2010 Technical Preview

• Sections  New

• MediaFormat and Bookmark triggers New

• SmartArt object New

PowerPoint 2007

• Extract text from SmartArt New

• Assign Picture Shape Type New

• How to jump to a particular animation during slideshow New

• Understanding Custom Layouts New

• How can I access the new text effects New

• Determine the shape type contained in a placeholder New

• Assign a glow to Shape and Text

• Reset slide layout

Automating PowerPoint from an external application

• Start a slide show and monitor it from an external application using events (2000+)

• Display PowerPoint slide show within a VB form or control window

• Start a slide show and monitor it from an external application

• Visual Basic Scripting example to Export a PowerPoint Presentation as JPEGs

VBA

• How to split a PowerPoint table. New

• How to print hyperlinked presentations

• How to determine the cursor position in slide sorter view

• How to add a menu item to the slideshow right-click menu

• Timeline – The animation engine in PowerPoint 2002/2003 - Part I

• How to copy designs from one presentation to another  (PPT 2002+)

• How to activate the outline/thumbnails tab (PPT 2002+)

• Add items to the 'New Presentation' task pane

• Enumerate Hyperlinks in a presentation and associated objects

• Inter-presentation communication

• Game of concentration

• Tic-Tac-Toe PowerPoint demo using VBA

• Show all...

Newbie Section

• Determine the current slide (Slide View mode)

• Determine the current slide (Slide Show mode)

• Difference between SlideIndex property and SlideNumber property

• Macro to exit all running slide shows (Slide show mode)

• Refresh the current slide (Slide show mode)

• Reset animation build for the current slide (Slide show mode)

• Insert a slide after current slide

General

• Add items to the 'New Presentation' task pane New

• Insert multiple images into a single slide (PPT 2002+) New

• How to clear the 'Recent files' list

• How to remove custom colors from the presentation

• OLE Objects and Charts saved in earlier versions appear flipped/inverted in PowerPoint XP.

• Create your own Animation Schemes in PowerPoint 2002/XP

• Disable the multiple clips feature of MS Office 2000/2002