Microsoft KB Archive/162231

Knowledge Base

PPT97: Macro to Export PowerPoint Slides as Graphics

Article ID: 162231

Article Last Modified on 10/11/2006

---

APPLIES TO

• Microsoft PowerPoint 97 Standard Edition

---

This article was previously published under Q162231

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. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers 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 requirements.

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:

163435 VBA: Programming Resources for Visual Basic for Applications

Additional query words: 97 8.00 kbpptvba file save as picture macro vba vbe

Keywords: kbcode kbdtacode kbhowto kbmacro kbprogramming KB162231

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.