Object: SheetDimensions

DIAdem 2018 Help


Edition Date: June 2018
Part Number: 370858P-01
View Product Info

DOWNLOAD (Windows Only)


DIAdem 2012 Help
DIAdem 2014 Help
DIAdem 2015 Help
DIAdem 2017 Help
DIAdem 2018 Help
DIAdem 2019 Help

The SheetDimensions object provides the properties of the page format in DIAdem REPORT.

The following example changes the page ratio and displays the value:

Dim oMyDimensions, oMySheetDimension
Set oMyDimensions = Report.Settings.Page.Dimensions
oMyDimensions.UseScaledOutput = False
oMyDimensions.Ratio = 1.5

Set oMySheetDimension = Report.ActiveSheet.Dimensions
oMySheetDimension.Orientation = ePageOrientationLandscape
oMySheetDimension.UseLocalSettings = True
Call MsgBoxDisp(oMySheetDimension.Ratio)

Returned From

Sheet.Dimensions

WAS THIS ARTICLE HELPFUL?

Not Helpful