Friday, August 16, 2013

An Overlooked Use of PowerPoint

MS PowerPoint is probably the least appreciated applications in MS Office. Often maligned for limiting creativity, MS PowerPoint gets little attention from developers. As of the writing of this post, there is no specific forum for MS PowerPoint on the Microsoft Developers Network Forums. Many of the snippets I've seen are written to update material in an existing presentation. Much like updating a report that will be presented on a regular basis, data is pushed or pulled into specific Placeholders, Text Ranges, and/or embedded Worksheets. As usual I applaud those of you out there that streamline processes this way.
A short while back, I was working on a report in MS Access. I had been using a MS Graph 12.0 Chart to illustrate some of the detail. The Chart worked well up to a point. Eventually, I had to incorporate information into the Chart in a way the Chart object did not support.
I knew what I needed to draw, and how to draw it; so, I embedded a MS PowerPoint Slide object into the report and added a script to the OnFormat Event. The script clears any unwanted graphics from the slide, loops through some recordsets, adds shapes, and formatting properties. The result is a small data generated metagraphic.

Example Slide Embedded in Report

The portion of the image on the left is the slide. The blurred portion on the right is another portion of the MS Access report.
If you ever find yourself needing a drawing canvas in another MS Office application, consider the often overlooked MS PowerPoint.



No comments:

Post a Comment