Microsoft KB Archive/162231: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
Line 60: | Line 60: | ||
' Set path equal to the desired file storage location. | ' Set path equal to the desired file storage location. | ||
Const path As String = | Const path As String = "c:" | ||
' Set filename equal to the desired name of the graphic file. | ' Set filename equal to the desired name of the graphic file. | ||
Const filename As String = | Const filename As String = "slide" & desired_slide | ||
' Set graphic_type equal to three letter | ' Set graphic_type equal to three letter | ||
' extension for your graphic type. | ' extension for your graphic type. | ||
Const graphic_type As String = | Const graphic_type As String = "png" | ||
' Set scalewidth equal to horizontal | ' Set scalewidth equal to horizontal | ||
Line 81: | Line 81: | ||
' Exports the desired slide as a graphic. | ' Exports the desired slide as a graphic. | ||
With Application.ActivePresentation.Slides(desired_slide) | With Application.ActivePresentation.Slides(desired_slide) | ||
.Export path & | .Export path & "\" & filename, graphic_type, scalewidth, _ | ||
scaleheight | scaleheight | ||
End With | End With | ||
MsgBox | MsgBox "you have successfully exported slide" & desired_slide _ | ||
& | & " to" & Chr(13) & path & "\" & filename & "." _ | ||
& graphic_type, _ | & graphic_type, _ | ||
vbInformation, | vbInformation, "Export Result" | ||
End Sub | End Sub |
Revision as of 11:00, 21 July 2020
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