<< Click to Display Table of Contents >> Window (object) |
Access paths:
▪Application à Windows à Item
▪Application à ActiveWindow
▪Application à Workbooks à Item à ActiveWindow
▪Application à ActiveWorkbook à ActiveWindow
1 Description
A Window object represents one individual document window that is currently open in PlanMaker.
An individual Window object exists for each document window. If you open or close document windows, the respective Window objects will be created or deleted dynamically.
2 Access to the object
The individual Window objects can be accessed in any of the following ways:
▪All open document windows are managed in the Application.Windows collection (type: Windows):
' Show the names of all open document windows
For i = 1 To pm.Application.Windows.Count
MsgBox pm.Application.Windows.Item(i).Name
Next i
▪You can access the currently active document window through Application.ActiveWindow:
' Show the name of the active document window
MsgBox pm.Application.ActiveWindow.Name
▪The object Workbook contains an object pointer to the respective document window:
' Access the active document window through the active document
MsgBox pm.Application.ActiveWorkbook.ActiveWindow.Name
3 Properties, objects, collections and methods
▪FullName R/O
▪Name R/O
▪Path R/O
▪Left
▪Top
▪Width
▪Height
▪WindowState
▪DisplayFormulas
▪DisplayVerticalScrollBar
▪DisplayHorizontalScrollBar
▪DisplayWorkbookTabs
▪DisplayHeadings
▪Zoom
▪DisplayGridlines
▪GridlineColor
▪GridlineColorIndex
Objects:
▪Workbook → Workbook
▪ActiveCell → Range
▪ActiveSheet → Sheet
▪Application → Application
▪Parent → Windows
Methods:
▪Activate
▪Close
FullName (property, R/O)
Data type: String
Returns the path and file name of the document opened in the window (e.g., "c:\Documents\Smith.pmdx").
Name (property, R/O)
Data type: String
Returns the file name of the document opened in the window (e.g., "Smith.pmdx").
Path (property, R/O)
Data type: String
Returns the path of the document opened in the window (e.g., "c:\Documents").
Left (property)
Data type: Long
Gets or sets the horizontal position of the window, measured in screen pixels.
Top (property)
Data type: Long
Gets or sets the vertical position of the window, measured in screen pixels.
Width (property)
Data type: Long
Gets or sets the width of the window, measured in screen pixels.
Height (property)
Data type: Long
Gets or sets the height of the window, measured in screen pixels.
WindowState (property)
Data type: Long (SmoWindowState)
Gets or sets the state of the document window. The possible values are:
smoWindowStateNormal = 1 ' normal
smoWindowStateMinimize = 2 ' minimized
smoWindowStateMaximize = 3 ' maximized
DisplayFormulas (property)
Data type: Boolean
Gets or sets the setting whether table cells containing calculations should display the result or the formula of the calculation.
DisplayVerticalScrollBar (property)
Data type: Boolean
Gets or sets the setting whether a vertical scroll bar should be shown on the righthand side of the document window. Corresponds to the setting "Vertical scrollbar" on the Options tab in the dialog box of the ribbon command File | Properties.
DisplayHorizontalScrollBar (property)
Data type: Boolean
Gets or sets the setting whether a horizontal scroll bar should be shown at the bottom of the document window. Corresponds to the setting "Horizontal scrollbar" on the Options tab in the dialog box of the ribbon command File | Properties.
DisplayWorkbookTabs (property)
Data type: Boolean
Gets or sets the setting whether worksheet tabs should be displayed at the bottom of the document window. Corresponds to the setting "Sheet tabs" on the Options tab in the dialog box of the ribbon command File | Properties.
DisplayHeadings (property)
Data type: Boolean
Gets or sets the setting whether row and column headers should be displayed in the document window. Corresponds to the ribbon command View | Row and column headers.
Notes:
▪This property is supported by PlanMaker only for Excel compatibility reasons. It is recommended to use the DisplayRowHeadings and DisplayColumnHeadings properties in the Sheet object instead, because these settings can be made independently for each worksheet and allow you to enable/disable row and column headers individually.
▪If you retrieve this property while multiple worksheets exist where this setting has different values, the value smoUndefined will be returned.
Zoom (property)
Data type: Long
Gets or sets the zoom level of the document window. Allowed are values between 50 and 400. They represent the zoom level in percent.
Alternatively, you can use the constant pmZoomFitToSelection which adapts the zoom level to the current selection.
Example:
' Set the zoom level to 120%
pm.ActiveWindow.Zoom = 120
Note: Changes to this setting affect only the current worksheet. If you want to change the zoom level of other worksheets as well, you have to make them the active worksheet first.
DisplayGridlines (property)
Data type: Boolean
Gets or sets the setting whether grid lines should be displayed in the document window. Corresponds to the "Gridlines" setting in the Insert | Tables group | Sheet | Properties dialog box of the ribbon command - except that the gridlines of all worksheets in the document are affected.
Notes:
▪This property is supported by PlanMaker only for Excel compatibility reasons. It is recommended to use the identically named property in the Sheet object instead, as it allows you to change this setting for each worksheet individually.
▪If you retrieve this property while multiple worksheets exist where this setting has different values, the value smoUndefined will be returned.
GridlineColor (property)
Data type: Long (SmoColor)
Gets or sets the color of the grid lines as a "BGR" value (Blue-Green-Red triplet). You can either indicate an arbitrary value or use one of the pre-defined BGR color constants.
Notes:
▪This property is supported by PlanMaker only for Excel compatibility reasons. It is recommended to use the identically named property in the Sheet object instead, as it allows you to change this setting for each worksheet individually.
▪If you retrieve this property while multiple worksheets exist where this setting has different values, the value smoUndefined will be returned.
GridlineColorIndex (property)
Data type: Long (SmoColorIndex)
Gets or sets the color of the grid lines as an index color. "Index colors" are the standard colors of PlanMaker, consecutively numbered from -1 for transparent to 15 for light gray. You may use the values shown in the Index colors table.
Notes:
▪This property is supported by PlanMaker only for Excel compatibility reasons. It is recommended to use the identically named property in the Sheet object instead, as it allows you to change this setting for each worksheet individually.
▪If you retrieve this property while multiple worksheets exist where this setting has different values, the value smoUndefined will be returned.
Workbook (pointer to object)
Data type: Object
Returns the Workbook object assigned to this document window. With this you can read and set numerous settings of your document.
ActiveCell (pointer to object)
Data type: Object
Returns a Range object that represents the active cell in this document window. You can use this object to read and edit the formatting and content of the cell.
Please note that ActiveCell always returns just one single cell, even if a range of cells is selected in the worksheet. After all, selected ranges have exactly one active cell as well. You can see that when you select cells and then press the Enter key: a cell frame appears within to selection to indicate the active cell.
ActiveSheet (pointer to object)
Data type: Object
Returns a Sheet object that represents the worksheet active in this document window. With this object you can read and edit the settings of the worksheet.
Application (pointer to object)
Data type: Object
Returns the Application object.
Parent (pointer to object)
Data type: Object
Returns the parent object, i.e. Windows.
Activate (method)
Brings the document window to the foreground (if the property Visible for this document is True) and sets the focus to it.
Syntax:
Activate
Parameters:
none |
Return type:
none |
Example:
' Activate the first document window
pm.Windows(1).Activate
Close (method)
Closes the document window.
Syntax:
Close [SaveChanges]
Parameters:
SaveChanges (optional; type: Long or SmoSaveOptions) indicates whether the document opened in the window should be saved or not (if it was changed since last save). If you omit this parameter, the user will be asked to indicate it (if necessary). The possible values for SaveChanges are: |
smoDoNotSaveChanges = 0 ' Don't ask, don't save
smoPromptToSaveChanges = 1 ' Ask the user
smoSaveChanges = 2 ' Save without asking
Return type:
none |
Example:
' Close the active document window, without saving
pm.ActiveWindow.Close smoDoNotSaveChanges