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>SheetNameSheetNumberAllSheets
|
| 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>FALSETRUE
|
| 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>FALSETRUE
|
| 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>FALSETRUE
|
| 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>FALSETRUE
|
| 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>FALSETRUE
|
| 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>FALSETRUE
|
| 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>FALSETRUE
|
| 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>DoNotCloseAlwaysCloseOnlyCloseOnSuccessfulBuild
|