Power Point Export Range Properties

The following properties are available on PowerPointExportRange objects, which appear as expandable sub-properties of the objects that use them.

General

Property	Type	Default	Description
ExportRangeType displayed as ExportType	PowerPointExportRangeType	PowerPointExportRangeType.Image	Whether to export a Chart or a worksheet range as an Image or Table.
Height	string		The height of the image in pixels. This property accepts formulas. If Height is specified it overrides other arguments that impact the height of the image. The height of the image is always limited by the height of the slide.
ImageName	string		The name of the image. ImageName can be left blank. This property accepts formulas.
Left	string		The horizontal position of the image on the slide. Left can be left blank. This property accepts formulas.
RangeAddress	string		Specifies the range to copy. Defaults to the sheet’s used range. This property accepts formulas.
ReplacePolicy	string		Whether to replace an image that has the same name. This property accepts formulas. None - The image will be added to the specified slide, if any. Otherwise the image will be added to a new slide. OnAnySlide - Every image with the same name on any slide (if any) would be replaced. If an image with the same name does not exist then the image would be added. PerSlideName - If an image with the specified name exists on the specified slide it would be replaced, otherwise it would be added. If ReplacePolicy is not specified PerSlideName will be used.
ScalePercent	string		Scale the image with a value between 10 and 400. The default is 100. This property accepts formulas.
SizePolicy	string		The size of the new image. This property accepts formulas. NewImage - Use the size of the specified range. ReplacedImage - Use the size of the image being replaced. If SizePolicy is not specified ReplacedImage will be used.
SlideName	string		The name or number of the slide. This property accepts formulas. Slide names can be listed in PowerPoint VBA using: Public Sub ListSlideNames() Dim oSlide As Slide For Each oSlide In Presentations(1).Slides Debug.Print "Slide " & oSlide.SlideIndex & ": " & oSlide.Name Next End Sub
Top	string		The vertical position of the image on the slide. Top can be left blank. This property accepts formulas.
Width	string		The width of the image in pixels. This property accepts formulas. If Width is specified it overrides other arguments that impact the width of the image. The width of the image is always limited by the width of the slide.

Property

Type

Default

Description

ExportRangeType
displayed as ExportType

PowerPointExportRangeType

PowerPointExportRangeType.Image

Whether to export a Chart or a worksheet range as an Image or Table.

Height

string

The height of the image in pixels. This property accepts formulas. If Height is specified it overrides other arguments that impact the height of the image. The height of the image is always limited by the height of the slide.

ImageName

string

The name of the image. ImageName can be left blank. This property accepts formulas.

Left

string

The horizontal position of the image on the slide. Left can be left blank. This property accepts formulas.

RangeAddress

string

Specifies the range to copy. Defaults to the sheet’s used range. This property accepts formulas.

ReplacePolicy

string

Whether to replace an image that has the same name. This property accepts formulas.

None - The image will be added to the specified slide, if any. Otherwise the image will be added to a new slide. OnAnySlide - Every image with the same name on any slide (if any) would be replaced. If an image with the same name does not exist then the image would be added. PerSlideName - If an image with the specified name exists on the specified slide it would be replaced, otherwise it would be added.

If ReplacePolicy is not specified PerSlideName will be used.

ScalePercent

string

Scale the image with a value between 10 and 400. The default is 100. This property accepts formulas.

SizePolicy

string

The size of the new image. This property accepts formulas.

NewImage - Use the size of the specified range. ReplacedImage - Use the size of the image being replaced.

If SizePolicy is not specified ReplacedImage will be used.

SlideName

string

The name or number of the slide. This property accepts formulas.

Slide names can be listed in PowerPoint VBA using:

Public Sub ListSlideNames() Dim oSlide As Slide For Each oSlide In Presentations(1).Slides Debug.Print "Slide " & oSlide.SlideIndex & ": " & oSlide.Name Next End Sub

Top

string

The vertical position of the image on the slide. Top can be left blank. This property accepts formulas.

Width

string

The width of the image in pixels. This property accepts formulas. If Width is specified it overrides other arguments that impact the width of the image. The width of the image is always limited by the width of the slide.