PPT97: Macro to Export PowerPoint Slides as Graphics

ID: Q162231

The information in this article applies to:

SUMMARY

The following Microsoft Visual Basic for Applications code can be used from within PowerPoint 97 to save a selected PowerPoint slide in a graphic file format.

MORE INFORMATION

Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes that you are familiar with the programming language being demonstrated and the tools used to create and debug procedures. Microsoft Support professionals can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific needs. If you have limited programming experience, you may want to contact the Microsoft fee-based consulting line at (800) 936-5200. For more information about the support options available from Microsoft, please see the following page on the World Wide Web:

   http://www.microsoft.com/support/supportnet/refguide/default.asp

Sample Visual Basic Procedure

   Sub savegraphic()

      ' Set desired_slide equal to the slide number to be exported.
      Const desired_slide As Long = 1

      ' Set path equal to the desired file storage location.
      Const path As String = "c:"

      ' Set filename equal to the desired name of the graphic file.
      Const filename As String = "slide" & desired_slide

      ' Set graphic_type equal to three letter
      ' extension for your graphic type.
      Const graphic_type As String = "png"

      ' Set scalewidth equal to horizontal
      ' width in pixels where 96 pixels = 1 inch.
      ' This parameter applies to PNG, GIF & JPG, but not WMF
      Const scalewidth As Long = 240

      ' Set scaleheight equal to vertical
      ' height in pixels where 96 pixels = 1 inch.
      ' This parameter applies to PNG, GIF & JPG, but not WMF
      Const scaleheight As Long = 192

      ' Exports the desired slide as a graphic.
      With Application.ActivePresentation.Slides(desired_slide)
         .Export path & "\" & filename, graphic_type, scalewidth, _
            scaleheight
      End With

      MsgBox "you have successfully exported slide" & desired_slide _
         & " to" & Chr(13) & path & "\" & filename & "." _
         & graphic_type, _
         vbInformation, "Export Result"

   End Sub

Graphic Formats Supported

The .export command supports WMF, JPG, GIF, and PNG.

Graphic Formats Not Supported

The following file formats are NOT supported by the .export command: BMP, CDR, CGM, DRW, EMF, EPS, PCD, PCX, PCT, TIF, and WPG

Optional Parameters for Scaling the Graphic

ScaleWidth and ScaleHeight are optional parameters that are valid for the PNG, GIF, and JPG file formats, but are ignored when exporting to the WMF file format. The value entered for these two parameters is the number of pixels desired for width and height. The PNG, GIF, and JPG graphics export at a rate of 96 pixels per inch. Since these two parameters are Longs, only integer values are valid. Any numbers to the right of the decimal point is ignored. An entry of 1 or less is also ignored.

No Save Over Protection

This macro does not warn against overwriting files with the same name. When you save a graphic to a folder that contains a graphic with the same name, the original graphic is overwritten by the new graphic.

REFERENCES

For additional information about getting help with Visual Basic for Applications, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q163435
   TITLE     : VBA: Programming Resources for Visual Basic for
               Applications

Additional query words: 97 8.00 kbpptvba file save as picture macro vba vbe
Keywords          : kbcode kbmacro kbprg kbdta kbdtacode kbpptvba 
Version           : WINDOWS:97
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbhowto

Last Reviewed: May 17, 1999