Open a specified view.
Overload Name | Description |
---|---|
General | Open a specified view, and optionally build and/or close the view. |
Open a specified view, and optionally build and/or close the view.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
ViewID | The ID of the view to open. |
AutoBuildOnOpen |
Whether the view should autobuild, or wait for the user to click the build button. Leave blank to use the view's AutoBuildOnOpen property.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
ShareViewTokens |
Whether the current view's tokens are added as tokens to the opened view. When added, the tokens are used to set default selections, when applicable, and can be referenced in workbook scripts, SQLPassthroughDataSets, etc. as used by the opened view.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
ShareSelectorTokens (8.0) |
Whether the current view's selector tokens are added as tokens to the opened view. When added, the tokens are used to set default selections, when applicable, and can be referenced in workbook scripts, SQLPassthroughDataSets, etc. as used by the opened view.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
ShowViewAsActiveWindow (8.0) |
Whether the opened view's window becomes the active window. By default, the view's window is activated.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
ErrorPropertyName (7.6) | (Optional) The name of the workbook script property that receives the error message if the opening or building of the view returns an exception. |
Close |
Controls whether the view should be closed after opening and automatically building. If specified, the ClosePolicy argument takes precedence over the Close argument. By default, if neither argument is specified, the view is not closed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
ClosePolicy (7.7) |
Controls whether the view should be closed after opening and automatically building. The ClosePolicy argument provides more control over whether the view is closed and, if specified, takes precedence over the Close argument. By default, if neither argument is specified, the view is not closed.
Specify one of the following values or an arbitrary value:
<blank> DoNotClose AlwaysClose OnlyCloseOnSuccessfulBuild
|