AutoGridDoc Object

 

The AutoGridDoc object represents a grid document. Grid objects are created by the Docu­ments.Open method of the Application object. Values within a grid are accessed through the XValue, YValue, and ZValue properties.

 

Properties

Application

FileFormat

FileName

FullName

Index [AutoMarker]

Index [Document, AutoWindow]

Name [Application, AutoShape]

Name [Document]

Name [WksRange]

NBlanked

NCols

NFilled

NNodes

NRows

Parent

Path [Application]

Path [Document]

Type [AutoExcelWin, AutoWindow]

Type [AutoShape]

Type [Document]

Windows [Application]

Windows [Document]

XMax

XMin

XSize

XValue

YMax

YMin

YSize

YValue

ZCoefSkewness

ZCoefVariation

ZInterQuartileRange

ZLowerQuartile

ZMax

ZMaximum

ZMean

ZMeanSquare

ZMedian

ZMedianAbsDev

ZMidRange

ZMin

ZMinimum

ZRange

ZRootMeanSquare

ZStandardDeviation

ZTrimMean

ZUpperQuartile

ZValue

ZVariance

 

Methods

Activate

Close [AutoExcelWin, AutoWindow]

Close [Document, Documents]

Maximize

Minimize

Move

NewWindow

Restore

Size

 

Example

The following script demonstrates how the grid object is used in reference to the Documents col­lection.

 

Sub Main

'Declares GrapherApp as an object

Dim GrapherApp As Object

 

'Creates an instance of the Grapher Application object

'and assigns it to the variable named "GrapherApp"

Set GrapherApp = CreateObject("Grapher.Application")

 

'Makes Grapher visible

GrapherApp.Visible = True

 

'Declares Grid as an object

Dim Grid As Object

 

'Creates a grid document in Grapher and

'assigns it to the variable named "Grid"

Set Grid = GrapherApp.Documents.Open(“helens2.grd”)

End Sub