AutoExcelWin Object

 

The AutoExcelWin object contains methods and properties for the Microsoft Excel window. This object is created by the Documents collection OpenExcelWks method or the Add method when using grfExcelWksDoc. The Workbook property returns the Excel worksheet object. Refer to the Excel automation documentation for more information on the Excel worksheet methods and properties.

 

Properties

Active

Application

Caption

Height

Left

Parent

Top

Type

Width

WindowState

Workbook

 

Methods

Activate

Close

 

Example

The following script demonstrates how the AutoExcelWin object is used.

 

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

 

'Open an Excel window

Set ExcelWks = GrapherApp.Documents.OpenExcelWks(GrapherApp.Path + "\Samples\criteria.xls")

End Sub