WBS Core, Dodeca 8.3

CartesianList

Build a DataCache based on the cartesian product of values from two or more delimited string lists.

DelimitedString

Build a DataCache from a list of values specified by a delimited string.

SQLPassthroughDataSet

Build a DataCache from a Dodeca SQLPassthroughDataSet.

URL

Build a DataCache from the values returned in XML format from a URL. Specify the URL in the ScriptText argument. The list values will be taken from any nodes named "value" like Single-column: <root><value>Value 1</value><value>Value 2</value><value>Value 3</value></root> Multi-column: <root><value><value>Value 1</value><value>Value 2</value><value>Value 3</value><value>Value 4</value><value>Value 5</value><value>Value 6</value><value>Value 7</value></value><value><value>Value 1</value><value>Value 2</value><value>Value 3</value><value>Value 4</value><value>Value 5</value><value>Value 6</value><value>Value 7</value></value></root>

DataCacheName

The name of the table will be used to lookup values from it.

Initialize

Whether to initiaze the DataCache.

AllowDuplicates

Whether the value of the first column in each row must be unique. If left blank then FALSE will be used.

TrimLeft

Whether to trim whitespace from the left of all values. If blank FALSE will be used.

TrimRight

Whether to trim whitespace from the right of all values. If blank FALSE will be used.

ScriptText

The text of the script that will be run. The script will receive token replacement before being run.

Shared

Whether to carry the DataCache forward when opening one view from another.

ListDelimiter

The delimiter to use to define the end of each List. The default is ",".

Delimiter

The delimiter to use to define the end of each value. The default is ";".

ScriptResultColumnCount

The number of columns that will be in each row of the script result.

DataCacheName

The name of the table will be used to lookup values from it.

Initialize

Whether to initiaze the DataCache.

AllowDuplicates

Whether the value of the first column in each row must be unique. If left blank then FALSE will be used.

TrimLeft

Whether to trim whitespace from the left of all values. If blank FALSE will be used.

TrimRight

Whether to trim whitespace from the right of all values. If blank FALSE will be used.

Shared

Whether to carry the DataCache forward when opening one view from another.

ScriptText

The text of the script that will be run. The script will receive token replacement before being run.

Delimiter

The delimiter to use to define the end of each value. The default is ";".

RowDelimiter

The delimiter to use to determine the end of each row of data.

DataCacheName

The name of the table will be used to lookup values from it.

Initialize

Whether to initiaze the DataCache.

AllowDuplicates

Whether the value of the first column in each row must be unique. If left blank then FALSE will be used.

TrimLeft

Whether to trim whitespace from the left of all values. If blank FALSE will be used.

TrimRight

Whether to trim whitespace from the right of all values. If blank FALSE will be used.

Shared

Whether to carry the DataCache forward when opening one view from another.

DataSetID

The QueryName of the SQLPassthroughDataSet to run.

DataCacheName

The name of the table will be used to lookup values from it.

Initialize

Whether to initiaze the DataCache.

AllowDuplicates

Whether the value of the first column in each row must be unique. If left blank then FALSE will be used.

TrimLeft

Whether to trim whitespace from the left of all values. If blank FALSE will be used.

TrimRight

Whether to trim whitespace from the right of all values. If blank FALSE will be used.

Shared

Whether to carry the DataCache forward when opening one view from another.

ScriptText

The text of the script that will be run. The script will receive token replacement before being run.

RangeAddress

Adds rows to a DataTableRange's sheet range. The rows are added to the DataTableRange's sheet range that contains the specified range's row and column.

RangeName

Adds rows to a DataTableRange's sheet range.

DataTableRangeAddress

The address that is used to identify the DataTableRange whose sheet range the rows are added to. For example, the address of the active cell can be used to identify the selected DataTableRange.

RowCount

The number of rows to add.

DataSetRangeName

The name of the view's SQLPassthroughDataSetRange that contains the DataTableRange definition.

DataTableRangeName

The name of the DataTableRange whose sheet range the rows are added to.

GroupSheetRangeName

For a DataTableRange that is configured to sort and/or group the DataTable rows, the name of the group's sheet range to which the rows are added.

RowCount

The number of rows to add.

WorkbookRange

Add a defined name to the workbook for a literal (specified string).

WorkbookValue

Add a defined name to the workbook for a value.

WorksheetRange

Add a defined name for a range.

WorksheetValue

Add a defined name for a value.

DefinedName

The new defined name.

RangeAddress

The range to associate with the defined name.

DefinedName

The new defined name.

Value

This option allows for a defined name for a value, as opposed to a defined name for a range.

DefinedName

The new defined name.

RangeAddress

The range to associate with the defined name.

DefinedName

The new defined name.

Value

This option allows for a defined name for a value, as opposed to a defined name for a range.

Boolean

Add a boolean property to the workbook script.

Double

Add a double property to the workbook script.

Integer

Add a integer property to the workbook script.

SpecifyDataType

Add a property of specified data-type to the workbook script.

String

Add a string property to the workbook script.

Initialize

Whether to initialize the property. If Initialize is not specified TRUE will be used. If the Property already exists, an Initialize value of TRUE will cause the value of the property to be set to an empty string before the method is executed.

PropertyName

The name of the new property.

Value

The value of the new property.

Shared

Whether to carry the property forward when opening one view from another.

Initialize

Whether to initialize the property. If Initialize is not specified TRUE will be used. If the Property already exists, an Initialize value of TRUE will cause the value of the property to be set to an empty string before the method is executed.

PropertyName

The name of the new property.

Value

The value of the new property.

Shared

Whether to carry the property forward when opening one view from another.

Initialize

Whether to initialize the property. If Initialize is not specified TRUE will be used. If the Property already exists, an Initialize value of TRUE will cause the value of the property to be set to an empty string before the method is executed.

PropertyName

The name of the new property.

Value

The value of the new property.

Shared

Whether to carry the property forward when opening one view from another.

Initialize

Whether to initialize the property. If Initialize is not specified TRUE will be used. If the Property already exists, an Initialize value of TRUE will cause the value of the property to be set to an empty string before the method is executed.

PropertyName

The name of the new property.

DataType

The data-type of the new property.

Value

The value of the new property.

AppendToValue

For a string property, controls whether to append the Value to the existing property value.

Shared

Whether to carry the property forward when opening one view from another.

Initialize

Whether to initialize the property. If Initialize is not specified TRUE will be used. If the Property already exists, an Initialize value of TRUE will cause the value of the property to be set to an empty string before the method is executed.

PropertyName

The name of the new property.

Value

The value of the new property.

AppendToValue

For a string property, controls whether to append the Value to the existing property value.

Delimiter

When AppendToValue is True, an optional delimiter to use to delimit each appended value.

Shared

Whether to carry the property forward when opening one view from another.

Application

Add an application token to the Dodeca application.

General

Add a temporary token to the Dodeca view.

TargetView

Add a view token to the target view.

View

Add a view token to the Dodeca view.

TokenName

The name of the new token.

Value

The value of the new token.

SyncTokens

Whether to sync the token table after adding the token. If not specified TRUE will be used.

TokenName

The name of the new token.

Value

The value of the new token.

TokenName

The name of the new token.

Value

The value of the new token.

SyncTokens

Whether to sync the token table after adding the token. If not specified TRUE will be used.

TokenName

The name of the new token.

Value

The value of the new token.

SyncTokens

Whether to sync the token table after adding the token. If not specified TRUE will be used.

InPositionByName

Insert a new worksheet at a position specified by sheet name.

InPositionByNumber

Insert a new worksheet at a position specified by sheet number.

ToBeginning

Insert a new worksheet in the position of first sheet.

ToEnd

Add a new worksheet as the last sheet.

NewSheetName

The new name of the new sheet.

SheetName

The name of the sheet that is in the position to insert the sheet at.

NewSheetName

The new name of the new sheet.

SheetNumber

The number position to insert the sheet at.

NewSheetName

The new name of the new sheet.

NewSheetName

The new name of the new sheet.

AttachFile

Attaches the specified file.

AttachFileShortcut

Creates a shortcut to the specified file and attaches the shortcut. This would typically be a file on a network drive.

AttachUrlShortcut

Creates a shortcut to the specified Url and attaches the shortcut.

Delete

Deletes one or more attachments. AttachmentID or KeyItems must be specified. If AttachmentID is specified one attachment may be deleted. KeyItems will be ignored. If KeyItems is specified more than one attachments may be deleted depending on the number of items that are attached to the intersection specified by the KeyItems. If Name is specified with KeyItems then all attachments at the intersection specified by the KeyItems having the specified name will be deleted.

Export

Exports one or more attachments. AttachmentID or KeyItems must be specified. If AttachmentID is specified one attachment may be exported. KeyItems will be ignored. If KeyItems is specified more than one attachments may be exported depending on the number of items that are attached to the intersection specified by the KeyItems. If Name is specified with KeyItems then all attachments at the intersection specified by the KeyItems having the specified name will be exported.

Open

Opens one attachments. AttachmentID or KeyItems must be specified. If AttachmentID is specified one attachment may be opened. KeyItems will be ignored. If KeyItems is specified the first attachment that is attached to the intersection specified by the KeyItems will be opened. If Name is specified with KeyItems the first attachment that is attached to the intersection specified by the KeyItems and has the specified name will be opened.

Filename

The name of the file to attach.

Folder

The path to the folder that contains the specified file.

Description

The description of the new attachment.

IncrementName

Whether to add a subscript, such as (2), to the name of the attachment if the comment being attached to already has an attachment with the same name. If blank TRUE will be used. If FALSE attachments with the same name will be overwritten.

KeyItems

A semicolon delimited list of key-value pairs such as "Year=Jan;Market=East;Scenario=Budget". Each key item must be expressed as <key>=<value>, where neither <key> nor <value> are blank. The @KeyItems(<Address>) function can be used to specify the KeyItems of a specific cell. If KeyItems is blank the KeyItems of the active cell (if any) will be used.

AllowedFileTypes

A semicolon delimited string of file types. ex: ".xlsx;.txt;.docx". Only attachments of the file types specified will be allowed to be attached. If not specified then all types are allowed except for restricted types.

MaximumFileSize

The maximum allowed file size of attachments in KB. If left blank the MaximumFileSize property of the associated CommentRange will be used.

MaximumAttachments

The maximum number of files that can be attached to a comment. If left blank the MaximumAttachments property of the associated CommentRange will be used.

UseDialog

Whether to use a file dialog to specify the file. If left blank FALSE will be used.

DialogTitle

A caption to use at the title of the file dialog.

DialogResultPropertyName

If specified a script property with the specified name will be created with result of the file dialog. The @PVal(<prpoperty-name>) function can be used to get the value.

IdPropertyName

If specified a script property with the specified name will be created with the exported attachmentId. The @PVal(<prpoperty-name>) function can be used to get the value.

FullFilePathPropertyName

If specified a script property with the specified name will be created with full path of the attached file. The @PVal(<prpoperty-name>) function can be used to get the value.

Filename

The name of the file to attach.

Folder

The path to the folder that contains the specified file.

Description

The description of the new attachment.

IncrementName

Whether to add a subscript, such as (2), to the name of the attachment if the comment being attached to already has an attachment with the same name. If blank TRUE will be used. If FALSE attachments with the same name will be overwritten.

KeyItems

A semicolon delimited list of key-value pairs such as "Year=Jan;Market=East;Scenario=Budget". Each key item must be expressed as <key>=<value>, where neither <key> nor <value> are blank. The @KeyItems(<Address>) function can be used to specify the KeyItems of a specific cell. If KeyItems is blank the KeyItems of the active cell (if any) will be used.

AllowedFileTypes

A semicolon delimited string of file types. ex: ".xlsx;.txt;.docx". Only attachments of the file types specified will be allowed to be attached. If not specified then all types are allowed except for restricted types.

MaximumAttachments

The maximum number of files that can be attached to a comment. If left blank the MaximumAttachments property of the associated CommentRange will be used.

UseDialog

Whether to use a file dialog to specify the file. If left blank FALSE will be used.

DialogTitle

A caption to use at the title of the file dialog.

DialogResultPropertyName

If specified a script property with the specified name will be created with result of the file dialog. The @PVal(<prpoperty-name>) function can be used to get the value.

IdPropertyName

If specified a script property with the specified name will be created with the exported attachmentId. The @PVal(<prpoperty-name>) function can be used to get the value.

FullFilePathPropertyName

If specified a script property with the specified name will be created with full path of the attached file. The @PVal(<prpoperty-name>) function can be used to get the value.

URL

The URL to create the shortcut for.

Name

The name of the attachment.

Description

The description of the new attachment.

IncrementName

Whether to add a subscript, such as (2), to the name of the attachment if the comment being attached to already has an attachment with the same name. If blank TRUE will be used. If FALSE attachments with the same name will be overwritten.

KeyItems

A semicolon delimited list of key-value pairs such as "Year=Jan;Market=East;Scenario=Budget". Each key item must be expressed as <key>=<value>, where neither <key> nor <value> are blank. The @KeyItems(<Address>) function can be used to specify the KeyItems of a specific cell. If KeyItems is blank the KeyItems of the active cell (if any) will be used.

MaximumAttachments

The maximum number of files that can be attached to a comment. If left blank the MaximumAttachments property of the associated CommentRange will be used.

UseDialog

Whether to use a file dialog to specify the file. If left blank FALSE will be used.

DialogTitle

A caption to use at the title of the file dialog.

DialogResultPropertyName

If specified a script property with the specified name will be created with result of the file dialog. The @PVal(<prpoperty-name>) function can be used to get the value.

UrlPropertyName

If specified a script property with the specified name will be created with a value of the new attachment's URL. The @PVal(<prpoperty-name>) function can be used to get the value.

NamePropertyName

If specified a script property with the specified name will be created with a value of the name of the attachment that was opened. The @PVal(<prpoperty-name>) function can be used to get the value.

DescriptionPropertyName

If specified a script property with the specified name will be created with a value of the new attachment's Description. The @PVal(<prpoperty-name>) function can be used to get the value.

IdPropertyName

If specified a script property with the specified name will be created with the exported attachmentId. The @PVal(<prpoperty-name>) function can be used to get the value.

AttachmentID

The AttachmentID.

Name

The name of the attachment.

KeyItems

A semicolon delimited list of key-value pairs such as "Year=Jan;Market=East;Scenario=Budget". Each key item must be expressed as <key>=<value>, where neither <key> nor <value> are blank. The @KeyItems(<Address>) function can be used to specify the KeyItems of a specific cell. If KeyItems is blank the KeyItems of the active cell (if any) will be used.

CountPropertyName

If specified a script property with the specified name will be created with count of the exported attachments. The @PVal(<prpoperty-name>) function can be used to get the value.

IdListPropertyName

If specified a script property with the specified name will be created with a semicolon delimited list of the effected attachment IDs.

AttachmentID

The AttachmentID.

Name

The name of the attachment.

KeyItems

A semicolon delimited list of key-value pairs such as "Year=Jan;Market=East;Scenario=Budget". Each key item must be expressed as <key>=<value>, where neither <key> nor <value> are blank. The @KeyItems(<Address>) function can be used to specify the KeyItems of a specific cell. If KeyItems is blank the KeyItems of the active cell (if any) will be used.

Folder

The path to the folder that contains the specified file.

FileExistsPolicy

Determines what to do if there is an existing file with the same name. If not specified Increment will be used. Increment = Add a sequence number to the file name like "FileName(1).txt". Overwrite = Overwrite the existing file. PromptForName = Prompt the user for a unique name. PromptForOverwrite = Prompt the user for whether to overwrite the file. SkipSilent = Do not export. SkipWithMessage = Prompt user with message that file was not exported.

UseDialog

Whether to use a file dialog to specify the file. If left blank FALSE will be used.

DialogTitle

A caption to use at the title of the file dialog.

DialogResultPropertyName

If specified a script property with the specified name will be created with result of the file dialog. The @PVal(<prpoperty-name>) function can be used to get the value.

CountPropertyName

If specified a script property with the specified name will be created with count of the exported attachments. The @PVal(<prpoperty-name>) function can be used to get the value.

FolderPropertyName

If specified a script property with the specified name will be created with the path of the output folder.

FilePathsListPropertyName

If specified a script property with the specified name will be created with a semicolon delimited list of the full paths of each exported file. The @PVal(<prpoperty-name>) function can be used to get the value.

IdListPropertyName

If specified a script property with the specified name will be created with a semicolon delimited list of the effected attachment IDs.

NamesListPropertyName

If specified a script property with the specified name will be created with a semicolon delimited list of the exported attachment names. The @PVal(<prpoperty-name>) function can be used to get the value.

AttachmentID

The AttachmentID.

Name

The name of the attachment.

KeyItems

A semicolon delimited list of key-value pairs such as "Year=Jan;Market=East;Scenario=Budget". Each key item must be expressed as <key>=<value>, where neither <key> nor <value> are blank. The @KeyItems(<Address>) function can be used to specify the KeyItems of a specific cell. If KeyItems is blank the KeyItems of the active cell (if any) will be used.

Folder

The path to the folder that contains the specified file.

FileExistsPolicy

Determines what to do if there is an existing file with the same name. If not specified Increment will be used. Increment = Add a sequence number to the file name like "FileName(1).txt". Overwrite = Overwrite the existing file. PromptForName = Prompt the user for a unique name. PromptForOverwrite = Prompt the user for whether to overwrite the file. SkipSilent = Do not export. SkipWithMessage = Prompt user with message that file was not exported.

UseDialog

Whether to use a file dialog to specify the file. If left blank FALSE will be used.

DialogTitle

A caption to use at the title of the file dialog.

DialogResultPropertyName

If specified a script property with the specified name will be created with result of the file dialog. The @PVal(<prpoperty-name>) function can be used to get the value.

FolderPropertyName

If specified a script property with the specified name will be created with the path of the output folder.

FullFilePathPropertyName

If specified a script property with the specified name will be created with full path of the attached file. The @PVal(<prpoperty-name>) function can be used to get the value.

NamePropertyName

If specified a script property with the specified name will be created with a value of the name of the attachment that was opened. The @PVal(<prpoperty-name>) function can be used to get the value.

IdPropertyName

If specified a script property with the specified name will be created with the exported attachmentId. The @PVal(<prpoperty-name>) function can be used to get the value.

AddSheet

Add a worksheet from the current view to a specified BinaryArtifact.

AddWorkbook

Add all worksheets from the current view to a specified BinaryArtifact

CreateFromFile

Create a BinaryArtifact from a file.

CreateFromSheet

Create a BinaryArtifact from a specified worksheet of the current view.

CreateFromWorkbook

Create a BinaryArtifact from the workbook of the current view.

Delete

Delete a specified BinaryArtifact.

ImportRange

Copy a specified range from a BinaryArtifact into the current view.

ImportSheet

Import a specified worksheet from a BinaryArtifact into the current view.

ImportWorkbook

Import all sheets from a specified BinaryArtifact into the current view.

SheetName

Specify the binary artifact sheet-name.

NewSheetName

If not blank the loaded sheet will be named per the specified NewSheetName.

ID

Specify the ID of the binary artifact. (Required)

VersionPolicy

Determines the Version to be used in saving the BinaryArtifact. If not specified and the SpecificVersion argument has no value then New will be used. Latest = latest version of the Binary Artifact. New = latest version of the Binary Artifact + 1. Specific = specified by the SpecificVersion argument.

SpecificVersion

The specific version to use for the Binary Artifact. (ignored if the VersionPolicy argument is not blank or set to Specific)

ValuesOnly

Whether to replace cell formulas with cell values. Default is FALSE.

ToPositionPolicy

Select how to specify where to copy the worksheet to. If left blank "Last" will be used.

ToPosition

If ToPositionPolicy is ToPositionOfSheetNamed then enter a sheet name. If ToPositionPolicy is ToPositionNumber then enter a number.

Password

The password assigned to the saved workbook.

ID

Specify the ID of the binary artifact. (Required)

VersionPolicy

Determines the Version to be used in saving the BinaryArtifact. If not specified and the SpecificVersion argument has no value then New will be used. Latest = latest version of the Binary Artifact. New = latest version of the Binary Artifact + 1. Specific = specified by the SpecificVersion argument.

SpecificVersion

The specific version to use for the Binary Artifact. (ignored if the VersionPolicy argument is not blank or set to Specific)

ValuesOnly

Whether to replace cell formulas with cell values. Default is FALSE.

ToPositionPolicy

Select how to specify where to copy the worksheet to. If left blank "Last" will be used.

ToPosition

If ToPositionPolicy is ToPositionOfSheetNamed then enter a sheet name. If ToPositionPolicy is ToPositionNumber then enter a number.

Password

The password assigned to the saved workbook.

Type

Specify the BinaryArtifact type. If left blank Excel will be used for Excel file types. Otherwise Other will be used.

Other: Specifies a text file of comma-separated values. Typically saved with the .csv filename extension. Excel: Specifies the Biff 8 File format which is the default file format of Excel 97, Excel 2000, Excel 2002 (XP) and Excel 2003. This format is also supported by Excel 2007-2016. Typically saved with the .xls filename extension.

ID

Specify the ID of the binary artifact. (Required)

Name

Specify the name of the binary artifact.

Description

Specify the description for the binary artifact.

VersionPolicy

Determines the Version to be used in saving the BinaryArtifact. If not specified and the SpecificVersion argument has no value then New will be used. Latest = latest version of the Binary Artifact. New = latest version of the Binary Artifact + 1. Specific = specified by the SpecificVersion argument.

SpecificVersion

The specific version to use for the Binary Artifact. (ignored if the VersionPolicy argument is not blank or set to Specific)

Filename

Specify the Filename of the binary artifact. When creating a BinaryArtifact, if Filename is left blank the BinaryArtifact's ID will be used.

Folder

Specify the full path to the folder that contains the file.

ValuesOnly

Whether to replace cell formulas with cell values. Default is FALSE.

Password

The password assigned to the saved workbook.

SheetName

Specify the binary artifact sheet-name.

Type

Specify the BinaryArtifact type. If left blank Excel will be used for Excel file types. Otherwise Other will be used.

Other: Specifies a text file of comma-separated values. Typically saved with the .csv filename extension. Excel: Specifies the Biff 8 File format which is the default file format of Excel 97, Excel 2000, Excel 2002 (XP) and Excel 2003. This format is also supported by Excel 2007-2016. Typically saved with the .xls filename extension.

ID

Specify the ID of the binary artifact. (Required)

Name

Specify the name of the binary artifact.

Description

Specify the description for the binary artifact.

VersionPolicy

Determines the Version to be used in saving the BinaryArtifact. If not specified and the SpecificVersion argument has no value then New will be used. Latest = latest version of the Binary Artifact. New = latest version of the Binary Artifact + 1. Specific = specified by the SpecificVersion argument.

SpecificVersion

The specific version to use for the Binary Artifact. (ignored if the VersionPolicy argument is not blank or set to Specific)

ValuesOnly

Whether to replace cell formulas with cell values. Default is FALSE.

Filename

Specify the Filename of the binary artifact. When creating a BinaryArtifact, if Filename is left blank the BinaryArtifact's ID will be used.

FileType

Specify the file type of saved workbook. Defaults to the current view's file type if not specified.

CSV: Specifies a text file of comma-separated values. Typically saved with the .csv filename extension. Excel8: Specifies the Biff 8 File format which is the default file format of Excel 97, Excel 2000, Excel 2002 (XP) and Excel 2003. This format is also supported by Excel 2007-2016. Typically saved with the .xls filename extension. OpenXMLWorkbook: Specifies the Excel 2007-2016 Open XML file format. Typically saved with the .xlsx filename extension. OpenXMLWorkbookMacroEnabled: Specifies the Excel 2007-2016 macro enabled Open XML file format. Typically saved with the .xlsm filename extension. UnicodeText: Specifies a tab-delimited Unicode text file encoded as UTF-8. Typically saved with the .txt filename extension.

Password

The password assigned to the saved workbook.

Type

Specify the BinaryArtifact type. If left blank Excel will be used for Excel file types. Otherwise Other will be used.

Other: Specifies a text file of comma-separated values. Typically saved with the .csv filename extension. Excel: Specifies the Biff 8 File format which is the default file format of Excel 97, Excel 2000, Excel 2002 (XP) and Excel 2003. This format is also supported by Excel 2007-2016. Typically saved with the .xls filename extension.

ID

Specify the ID of the binary artifact. (Required)

Name

Specify the name of the binary artifact.

Description

Specify the description for the binary artifact.

VersionPolicy

Determines the Version to be used in saving the BinaryArtifact. If not specified and the SpecificVersion argument has no value then New will be used. Latest = latest version of the Binary Artifact. New = latest version of the Binary Artifact + 1. Specific = specified by the SpecificVersion argument.

SpecificVersion

The specific version to use for the Binary Artifact. (ignored if the VersionPolicy argument is not blank or set to Specific)

ValuesOnly

Whether to replace cell formulas with cell values. Default is FALSE.

Filename

Specify the Filename of the binary artifact. When creating a BinaryArtifact, if Filename is left blank the BinaryArtifact's ID will be used.

FileType

Specify the file type of saved workbook. Defaults to the current view's file type if not specified.

CSV: Specifies a text file of comma-separated values. Typically saved with the .csv filename extension. Excel8: Specifies the Biff 8 File format which is the default file format of Excel 97, Excel 2000, Excel 2002 (XP) and Excel 2003. This format is also supported by Excel 2007-2016. Typically saved with the .xls filename extension. OpenXMLWorkbook: Specifies the Excel 2007-2016 Open XML file format. Typically saved with the .xlsx filename extension. OpenXMLWorkbookMacroEnabled: Specifies the Excel 2007-2016 macro enabled Open XML file format. Typically saved with the .xlsm filename extension. UnicodeText: Specifies a tab-delimited Unicode text file encoded as UTF-8. Typically saved with the .txt filename extension.

Password

The password assigned to the saved workbook.

ID

Specify the ID of the binary artifact. (Required)

DeleteVersionPolicy

Determines the Version of the BinaryArtifact to be deleted. If not specified and the SpecificVersion argument has no value then Latest will be used. All = all versions of the Binary Artifact. Latest = latest version of the Binary Artifact. Specific = specified by the SpecificVersion argument.

SpecificVersion

The specific version to use for the Binary Artifact. (ignored if the VersionPolicy argument is not blank or set to Specific)

ID

Specify the ID of the binary artifact. (Required)

ImportVersionPolicy

Determines the BinaryArtifact version to be imported from. If not specified and the SpecificVersion argument has no value then Latest will be used. Latest = latest version of the Binary Artifact. Specific = specified by the SpecificVersion argument.

SpecificVersion

The specific version to use for the Binary Artifact. (ignored if the VersionPolicy argument is not blank or set to Specific)

CopyRange

The range from the specified BinaryArtifact that will be copied into the current workbook.

PasteRange

The address in the current workbook to copy the CopyRange's cells to.

OutputRangeName

The range where the range is imported to will be given the specified name.

InsertPolicy

Determines whether/how to insert the copied range. If not specified then the copied range will overwrite the paste range. <blank> = Overwrite the paste range Rows = Insert the number of rows in the from-range at the first row of the paste range. Columns = Insert the number of columns in the from-range at the first column of the paste range. RowsAndColumns = Insert both rows and columns. ShiftCellsRight = Shift the cells in the paste range to the right. ShiftCellsDown = Shift the cells in the paste range to down.

PasteType

Specifies the type of paste to perform.

PasteOperation

Specifies an operation to perform on the numbers of the copied data (Add, Subtract, Multiply, or Divide).

CopyColumnWidths

Whether to copy the column widths of the copy range.

CopyRowHeights

Whether to copy the row heights of the copy range.

SkipBlanks

If cells in the copy range are empty, then the corresponding cells in the paste range are left unchanged. Defaults to FALSE if left blank. For consistency with the standard paste tool, this value should be set to TRUE.

Transpose

Rows become columns. Columns become rows.

Password

The password assigned to the saved workbook.

ID

Specify the ID of the binary artifact. (Required)

ImportVersionPolicy

Determines the BinaryArtifact version to be imported from. If not specified and the SpecificVersion argument has no value then Latest will be used. Latest = latest version of the Binary Artifact. Specific = specified by the SpecificVersion argument.

SpecificVersion

The specific version to use for the Binary Artifact. (ignored if the VersionPolicy argument is not blank or set to Specific)

ValuesOnly

Whether to replace cell formulas with cell values. Default is FALSE.

SheetName

Specify the binary artifact sheet-name.

NewSheetName

If not blank the loaded sheet will be named per the specified NewSheetName.

ToPositionPolicy

Select how to specify where to copy the worksheet to. If left blank "Last" will be used.

ToPosition

If ToPositionPolicy is ToPositionOfSheetNamed then enter a sheet name. If ToPositionPolicy is ToPositionNumber then enter a number.

Password

The password assigned to the saved workbook.

ID

Specify the ID of the binary artifact. (Required)

ImportVersionPolicy

Determines the BinaryArtifact version to be imported from. If not specified and the SpecificVersion argument has no value then Latest will be used. Latest = latest version of the Binary Artifact. Specific = specified by the SpecificVersion argument.

SpecificVersion

The specific version to use for the Binary Artifact. (ignored if the VersionPolicy argument is not blank or set to Specific)

ToPositionPolicy

Select how to specify where to copy the worksheet to. If left blank "Last" will be used.

ToPosition

If ToPositionPolicy is ToPositionOfSheetNamed then enter a sheet name. If ToPositionPolicy is ToPositionNumber then enter a number.

Password

The password assigned to the saved workbook.

General

Builds a SQLPassthroughDataSetRange.

DataSetRangeName

The name of the view's SQLPassthroughDataSetRange to build.

CoverDuringBuild

Controls whether the view is covered while the build is running.

CartesianList

Build a range on the sheet based on the cartesian product of values from two or more delimited string lists.

DataCache

Build a range on the sheet based on a DataCache created using the AddDataCache method.

DelimitedString

Loop a list of values specified by a delimited string.

ImportRange

Copy a specified range from a BinaryArtifact into the current view.

SQLPassthroughDataSet

Build a range on the sheet based on a Dodeca SQLPassthroughDataSet.

URL

Loop values returned in XML format from a URL. Nodes named "value" will be used in the loop.

ScriptText

The text of the script that will be run. The script will receive token replacement before being run.

ListDelimiter

The delimiter to use to define the end of each List.

Delimiter

The delimiter to use to define the end of each value.

StartCell

The address of the cell that the first row of script output goes into.

ScriptResultColumnCount

The number of columns that will be in each row of the script result.

OutputMap

A comma delimited string of rows or columns that the columns of the script results are written to. If BuildRowsOrColumns is Rows, then the script result's columns are written to the specified columns. If BuildRowsOrColumns is Columns, then the script result's columns are written to the specified rows.

BuildRowsOrColumns

Whether to build rows or columns from the script results.

EnterDatesAsText

Whether to treat a date value as text. When set to False, each valid date or date/time value returned by the script will be assigned to the cell as a date value. The number format of a cell that contains a date value should be set to Date; otherwise, the cell value will appear as the numeric value that is stored by Excel internally to represent dates. By default, EnterDatesAsText is True.

EnterNumbersAsText

Whether to put a quote on numeric values so that the grid interprets them as text. By default, EnterNumbersAsText is False.

HandleDuplicates

Whether to suppress a value if it is the same as the value in the row above.

CopyFromRange

The specified range will be copied for each row of output from the script.

CopyToRange

Specifies where the CopyFromRange will be copied to.

DoInsert

Whether to insert the value or simply put it in the next cell. ---DoInsert overrides the Insert Argument.---

Insert

Whether to insert the value or simply put it in the next cell.

OutputRangeName

The range where the script output is put will be given the specified name.

DataCacheName

The name of the data-cache to build the range from.

SortOrder

Specifies one or more columns of the DataCache to sort by.

Example: Col1 Example: Col1, Col3 Example: "Col2 DESC, Col1 ASC"

StartCell

The address of the cell that the first row of script output goes into.

ScriptResultColumnCount

The number of columns that will be in each row of the script result.

OutputMap

A comma delimited string of rows or columns that the columns of the script results are written to. If BuildRowsOrColumns is Rows, then the script result's columns are written to the specified columns. If BuildRowsOrColumns is Columns, then the script result's columns are written to the specified rows.

BuildRowsOrColumns

Whether to build rows or columns from the script results.

EnterDatesAsText

Whether to treat a date value as text. When set to False, each valid date or date/time value returned by the script will be assigned to the cell as a date value. The number format of a cell that contains a date value should be set to Date; otherwise, the cell value will appear as the numeric value that is stored by Excel internally to represent dates. By default, EnterDatesAsText is True.

EnterNumbersAsText

Whether to put a quote on numeric values so that the grid interprets them as text. By default, EnterNumbersAsText is False.

HandleDuplicates

Whether to suppress a value if it is the same as the value in the row above.

CopyFromRange

The specified range will be copied for each row of output from the script.

CopyToRange

Specifies where the CopyFromRange will be copied to.

DoInsert

Whether to insert the value or simply put it in the next cell. ---DoInsert overrides the Insert Argument.---

Insert

Whether to insert the value or simply put it in the next cell.

OutputRangeName

The range where the script output is put will be given the specified name.

ScriptText

The text of the script that will be run. The script will receive token replacement before being run.

Delimiter

The delimiter to use to define the end of each value.

StartCell

The address of the cell that the first row of script output goes into.

ScriptResultColumnCount

The number of columns that will be in each row of the script result.

OutputMap

A comma delimited string of rows or columns that the columns of the script results are written to. If BuildRowsOrColumns is Rows, then the script result's columns are written to the specified columns. If BuildRowsOrColumns is Columns, then the script result's columns are written to the specified rows.

BuildRowsOrColumns

Whether to build rows or columns from the script results.

EnterDatesAsText

Whether to treat a date value as text. When set to False, each valid date or date/time value returned by the script will be assigned to the cell as a date value. The number format of a cell that contains a date value should be set to Date; otherwise, the cell value will appear as the numeric value that is stored by Excel internally to represent dates. By default, EnterDatesAsText is True.

EnterNumbersAsText

Whether to put a quote on numeric values so that the grid interprets them as text. By default, EnterNumbersAsText is False.

CopyFromRange

The specified range will be copied for each row of output from the script.

CopyToRange

Specifies where the CopyFromRange will be copied to.

DoInsert

Whether to insert the value or simply put it in the next cell. ---DoInsert overrides the Insert Argument.---

Insert

Whether to insert the value or simply put it in the next cell.

OutputRangeName

The range where the script output is put will be given the specified name.

ID

Specify the ID of the binary artifact. (Required)

VersionPolicy

Determines the Version of the BinaryArtifact to be used. If not specified and the SpecificVersion argument has no value then Latest will be used. Latest = latest version of the Binary Artifact. Specific = specified by the SpecificVersion argument.

SpecificVersion

The specific version to use for the BinaryArtifact. (ignored if the VersionPolicy argument is not blank or set to Specific)

CopyRange

The range from the specified BinaryArtifact that will be copied into the current workbook.

PasteRange

The address in the current workbook to copy the CopyRange's cells to.

OutputRangeName

The range where the script output is put will be given the specified name.

InsertPolicy

Determines whether/how to insert the copied range. If not specified then the copied range will overwrite the paste range. <blank> = Overwrite the paste range Rows = Insert the number of rows in the from-range at the first row of the paste range. Columns = Insert the number of columns in the from-range at the first column of the paste range. RowsAndColumns = Insert both rows and columns. ShiftCellsRight = Shift the cells in the paste range to the right. ShiftCellsDown = Shift the cells in the paste range to down.

PasteType

Specifies the type of paste to perform.

PasteOperation

Specifies an operation to perform on the numbers of the copied data (Add, Subtract, Multiply, or Divide).

CopyColumnWidths

Whether to copy the column widths of the copy range. The default is FALSE.

CopyRowHeights

Whether to copy the row heights of the copy range. The default is FALSE.

SkipBlanks

If cells in the copy range are empty, then the corresponding cells in the paste range are left unchanged. Defaults to FALSE if left blank. For consistency with the standard paste tool, this value should be set to TRUE.

Transpose

Rows become columns. Columns become rows.

Password

The password of the BinaryArtifact workbook.

DataSetID

The QueryName of the SQLPassthroughDataSet to run.

StartCell

The address of the cell that the first row of script output goes into.

BuildRowsOrColumns

Whether to build rows or columns from the script results.

EnterDatesAsText

Whether to treat a date value as text. When set to False, each valid date or date/time value returned by the script will be assigned to the cell as a date value. The number format of a cell that contains a date value should be set to Date; otherwise, the cell value will appear as the numeric value that is stored by Excel internally to represent dates. By default, EnterDatesAsText is True.

EnterNumbersAsText

Whether to put a quote on numeric values so that the grid interprets them as text. By default, EnterNumbersAsText is False.

CopyFromRange

The specified range will be copied for each row of output from the script.

CopyToRange

Specifies where the CopyFromRange will be copied to.

DoInsert

Whether to insert the value or simply put it in the next cell. ---DoInsert overrides the Insert Argument.---

Insert

Whether to insert the value or simply put it in the next cell.

OutputRangeName

The range where the script output is put will be given the specified name.

OutputMap

A comma delimited string of rows or columns that the columns of the script results are written to. If BuildRowsOrColumns is Rows, then the script result's columns are written to the specified columns. If BuildRowsOrColumns is Columns, then the script result's columns are written to the specified rows.

ExecuteQueryAsynchronous

Whether the query is executed asynchronously on a background thread.

ScriptText

The text of the script that will be run. The script will receive token replacement before being run.

StartCell

The address of the cell that the first row of script output goes into.

BuildRowsOrColumns

Whether to build rows or columns from the script results.

EnterDatesAsText

Whether to treat a date value as text. When set to False, each valid date or date/time value returned by the script will be assigned to the cell as a date value. The number format of a cell that contains a date value should be set to Date; otherwise, the cell value will appear as the numeric value that is stored by Excel internally to represent dates. By default, EnterDatesAsText is True.

EnterNumbersAsText

Whether to put a quote on numeric values so that the grid interprets them as text. By default, EnterNumbersAsText is False.

CopyFromRange

The specified range will be copied for each row of output from the script.

CopyToRange

Specifies where the CopyFromRange will be copied to.

DoInsert

Whether to insert the value or simply put it in the next cell. ---DoInsert overrides the Insert Argument.---

Insert

Whether to insert the value or simply put it in the next cell.

OutputRangeName

The range where the script output is put will be given the specified name.

OutputMap

A comma delimited string of rows or columns that the columns of the script results are written to. If BuildRowsOrColumns is Rows, then the script result's columns are written to the specified columns. If BuildRowsOrColumns is Columns, then the script result's columns are written to the specified rows.

General

Build the view.

CoverDuringBuild

Controls whether the view is covered during the build.

AllWorkbooksAsNeeded

Calculates formulas in all workbooks as needed. Volatile formulas and formulas involved in circular references are always calculated.

AllWorkbooksFull

Calculates all formulas in all workbooks.

General

Set the Cancel property of the event that called the procedure. Not all events are cancelable.

Cancel

A value of true will cancel the event that called the procedure. It will not stop the execution of the procedure.

OnCancelProcedure

The name of the procedure to execute if Cancel gets set to True.

General

Clear All, Excel Comments, Contents, or Formats from a specified range.

Clear

Whether to clear All, Contents, Formats, or Excel Comments.

General

Closes the view.

Close

Determines whether the view is closed.

General

Closes the application.

Close

Controls whether the application is closed.

ExitCode

The exit code returned by the application. Leave blank to return the standard exit code 0.

Add

Add a Dodeca comment.

Copy

Copies comments from one or more sets of intersections to one or more other sets of intersections.

DeleteByCommentID

Delete the Dodeca comment that has the specified CommentID.

DeleteByKeyHash

Delete all Dodeca comments that have the specified KeyHash.

DeleteByKeyItems

Delete all Dodeca comments that have the specified KeyItems.

Load

Load comments for the specified worksheet(s).

Save

Save the view's Dodeca comments.

CommentText

The text of the new comment.

KeyItems

A semicolon delimited list of key-value pairs such as "Year=Jan;Market=East;Scenario=Budget". Each key item must be expressed as <key>=<value>, where neither <key> nor <value> are blank. The @KeyItems(<Address>) function can be used to specify the KeyItems of a specific cell. If KeyItems is blank the KeyItems of the active cell (if any) will be used.

Context

The Context of the Comment.

Subject

The Subject of the comment.

ParentCommentID

The ID of the comment's parent comment. This would be used if the comment is a response to another.

NewCommentIdPropertyName

The name of a script property which will be set to the ID of the comment.

NewKeyHashPropertyName

The name of a script property which will be set to the KeyHash of the comment.

Source

The set of key/value pairs that defines the filter for the source intersections from which comments will be copied. The source is expressed as key/value pairs, in the form of Key=Value, where the pairs are separated by a semi-colon character. Multiple sets of key/value pairs may be passed using a pipe delimiter to separate different sets.

Example: Scenario=Budget;Year=Jan|Scenario=Budget;Year=Feb

Note: The number of key/value pairs and the number of sets much exactly match the number of key/value pairs and the number of sets passed in the Target argument.

Target

The set of key/value pairs that defines the filter for the target intersections where comments will be copied. The target is expressed as key/value pairs, in the form of Key=Value, where the pairs are separated by a semi-colon character. Multiple sets of key/value pairs may be passed using a pipe delimiter to separate different sets.

Example: Scenario=Forecast;Year=Jan|Scenario=Forecast;Year=Feb

Note: The number of key/value pairs and the number of sets much exactly match the number of key/value pairs and the number of sets passed in the Source argument.

BackgroundExecute

Controls whether the method is executed asynchronous.

CommentID

The ID of the comment.

DeletedCountPropertyName

The name of a script property which will be set to the count of deleted comments.

KeyHash

The KeyHash to match for comments. The KeyHash represents a specific set a KeyItems. All comments with the specified KeyHash will be impacted.

DeletedCountPropertyName

The name of a script property which will be set to the count of deleted comments.

KeyItems

A semicolon delimited list of key-value pairs such as "Year=Jan;Market=East;Scenario=Budget". Each key item must be expressed as <key>=<value>, where neither <key> nor <value> are blank. The @KeyItems(<Address>) function can be used to specify the KeyItems of a specific cell. If KeyItems is blank the KeyItems of the active cell (if any) will be used.

MatchAny

If FALSE, then comments that have all of and ONLY the specified KeyItems will be matched. MatchAny is FALSE by default. SPECIFYING TRUE SHOULD BE DONE WITH CAUTION. If TRUE, then comments that have all of the specified KeyItems will be matched, even though they may also have other KeyItems as well. MatchAny only functions on comments that are in context in the view.

DeletedCountPropertyName

The name of a script property which will be set to the count of deleted comments.

General

Copies comments from one or more sets of intersections to one or more other sets of intersections.

Source

The set of key/value pairs that defines the filter for the source intersections from which comments will be copied. The source is expressed as key/value pairs, in the form of Key=Value, where the pairs are separated by a semi-colon character. Multiple sets of key/value pairs may be passed using a pipe delimiter to separate different sets.

Example: Scenario=Budget;Year=Jan|Scenario=Budget;Year=Feb

Note: The number of key/value pairs and the number of sets much exactly match the number of key/value pairs and the number of sets passed in the Target argument.

Target

The set of key/value pairs that defines the filter for the target intersections where comments will be copied. The target is expressed as key/value pairs, in the form of Key=Value, where the pairs are separated by a semi-colon character. Multiple sets of key/value pairs may be passed using a pipe delimiter to separate different sets.

Example: Scenario=Forecast;Year=Jan|Scenario=Forecast;Year=Feb

Note: The number of key/value pairs and the number of sets much exactly match the number of key/value pairs and the number of sets passed in the Source argument.

BackgroundExecute

Controls whether the method is executed asynchronous.

Range

Copy a range and specify the paste options.

Sheet

Copy a worksheet.

BinaryArtifactID

The ID of the source Excel Binary Artifact.

VersionPolicy

Determines the version to be used. If not specified and the BinaryArtifactVersion argument has no value, then Latest will be used. Latest = latest version of the Binary Artifact Specific = specified by the BinaryArtifactVersion argument

BinaryArtifactVersion

The version of the source Excel Binary Artifact. Leave blank to always use the most recent version.

Password

If the copy-from workbook is password-protected, specifies the password assigned to the workbook. NOTE: The password is currently only supported for XLS files that are saved from Excel 2010.

CopyRange

The address of the range to copy from.

PasteRange

The address of the range to paste into.

OutputRangeName

The range where the range is imported to will be given the specified name.

InsertPolicy

Determines whether/how to insert the copied range. If not specified then the copied range will overwrite the paste range. <blank> = Overwrite the paste range Rows = Insert the number of rows in the from-range at the first row of the paste range. Columns = Insert the number of columns in the from-range at the first column of the paste range. RowsAndColumns = Insert both rows and columns. ShiftCellsRight = Shift the cells in the paste range to the right. ShiftCellsDown = Shift the cells in the paste range to down.

PasteType

Specifies the type of copy to perform.

PasteOperation

Specifies an operation to perform on the numbers of the copied data (Add, Subtract, Multiply, or Divide).

CopyColumnWidths

Whether to copy the column widths of the copy range.

CopyRowHeights

Whether to copy the row heights of the copy range.

SkipBlanks

If cells in the copy range are empty, then the corresponding cells in the paste range are left unchanged. Defaults to FALSE if left blank. For consistency with the standard paste tool, this value should be set to TRUE.

Transpose

Rows become columns. Columns become rows.

BinaryArtifactID

The ID of the source Excel Binary Artifact.

BinaryArtifactVersion

The version of the source Excel Binary Artifact. Leave blank to always use the most recent version.

Password

If the copy-from workbook is password-protected, specifies the password assigned to the workbook. NOTE: The password is currently only supported for XLS files that are saved from Excel 2010.

SpecifyFromBy

Select how to specify which worksheet to copy.

FromSheetSpec

Specify the sheet-name or sheet-number, depending on SpecifyFromBy.

SpecifyToPosition

Select how to specify where to copy the worksheet to.

ToPosition

If SpecifyToPosition is ToPositionOfSheetNamed then enter a sheet name. If SpecifyToPosition is ToPositionNumber then enter a number.

NewSheetName

The name of the new sheet.

AsImage

Copy a specified workbook range as an image to a specified location.

ColumnWidth

Copy the column widths of a specified range.

FromFile

Copy a specified range from an Excel or delimited file into the current view.

General

Copy a specified range.

RowHeight

Copy the row heights a specified range.

Specify

Copy a range and specify the paste options.

ToClipboardAsImage

Copy a specified workbook range to the clipboard as an image.

ToFileAsImage

Copy a specified workbook range to an image file.

CopyRange

The address of the range to copy.

ImageName

The name assigned to the image. This can be used to identify the image after it is created.

OnClickProcedure

The name of the procedure to execute when the image is clicked. The worksheet must be protected and the image locked for OnClick to work.

Placement

The placement behavior of the image. FreeFloating: Do not move with cells. Move: Move with cells. MoveAndSize: Move and size with cells.

Column

The column to put the image into. 0.0 is the left edge of the first column. 0.5 is the middle of the first column, etc. If used with the ColumnPoints argument then the two are added together.

EndColumn

The column the will define the width of the image. The Width argument can be used instead of this.

ColumnPoints

The position of the left edge of the image in points. If used with the Column argument then the two are added together.

Row

The row to put the image into. 0.0 is the top edge of the first row. 0.5 is the middle of the first row, etc. If used with the RowPoints argument then the two are added together.

EndRow

The row the will define the height of the image. The Height argument can be used instead of this.

RowPoints

The position of the top edge of the image in points. If used with the Row argument then the two are added together.

Width

The width of the image in points. The EndColumn argument can be used instead of this.

Height

The height of the image in points. The EndRow argument can be used instead of this.

LockAspectRatio

Whether the image's aspect ratio is locked.

Locked

Whether the image is locked.

Visible

Whether the image is visible.

PrintImage

Whether to print the image.

BorderColor

Select the color for the border's forecolor.

BorderColorIndex

Excel color palette index to use for the border's forecolor. The value is zero-based from 0 to 55.

BorderTransparency

From 0.0 to 1.0 (opaque to transparent).

BorderVisible

Whether the border is visible.

BorderWeight

The weight of the border, in points.

CopyRange

The address of the range to copy.

PasteRange

The address of the range to paste into.

Filename

Specify the name of the file to copy from.

Folder

Specify the full path to the folder to put the file in. If left blank the Desktop folder will be used.

CopyRange

The address of the range to copy.

PasteRange

The address of the range to paste into.

OutputRangeName

The range where the range is imported to will be given the specified name.

InsertPolicy

Determines whether/how to insert the copied range. If not specified then the copied range will overwrite the paste range. <blank> = Overwrite the paste range Rows = Insert the number of rows in the from-range at the first row of the paste range. Columns = Insert the number of columns in the from-range at the first column of the paste range. RowsAndColumns = Insert both rows and columns. ShiftCellsRight = Shift the cells in the paste range to the right. ShiftCellsDown = Shift the cells in the paste range to down.

PasteType

Specifies the type of copy to perform.

PasteOperation

Specifies an operation to perform on the numbers of the copied data (Add, Subtract, Multiply, or Divide).

CopyColumnWidths

Whether to copy the column widths of the copy range. If left blank TRUE will be used.

CopyRowHeights

Whether to copy the row heights of the copy range. If left blank TRUE will be used.

SkipBlanks

If cells in the copy range are empty, then the corresponding cells in the paste range are left unchanged. Defaults to FALSE if left blank. For consistency with the standard paste tool, this value should be set to TRUE.

Transpose

Rows become columns. Columns become rows.

Password

If the copy-from workbook is password-protected, specifies the password assigned to the workbook. NOTE: The password is currently only supported for XLS files that are saved from Excel 2010.

CopyRange

The address of the range to copy.

PasteRange

The address of the range to paste into.

Cut

If true the values of the cells copied from will be cleared.

InsertPolicy

Determines whether/how to insert the copied range. If not specified then the copied range will overwrite the paste range. <blank> = Overwrite the paste range Rows = Insert the number of rows in the from-range at the first row of the paste range. Columns = Insert the number of columns in the from-range at the first column of the paste range. RowsAndColumns = Insert both rows and columns. ShiftCellsRight = Shift the cells in the paste range to the right. ShiftCellsDown = Shift the cells in the paste range to down.

CopyRange

The address of the range to copy.

PasteRange

The address of the range to paste into.

CopyRange

The address of the range to copy.

PasteRange

The address of the range to paste into.

Cut

If true the values of the cells copied from will be cleared.

InsertPolicy

Determines whether/how to insert the copied range. If not specified then the copied range will overwrite the paste range. <blank> = Overwrite the paste range Rows = Insert the number of rows in the from-range at the first row of the paste range. Columns = Insert the number of columns in the from-range at the first column of the paste range. RowsAndColumns = Insert both rows and columns. ShiftCellsRight = Shift the cells in the paste range to the right. ShiftCellsDown = Shift the cells in the paste range to down.

PasteType

Specifies the type of copy to perform.

PasteOperation

Specifies an operation to perform on the numbers of the copied data (Add, Subtract, Multiply, or Divide).

SkipBlanks

If cells in the copy range are empty, then the corresponding cells in the paste range are left unchanged. Defaults to FALSE if left blank. For consistency with the standard paste tool, this value should be set to TRUE.

Transpose

Rows become columns. Columns become rows.

CopyRange

The address of the range to copy.

ScalePercent

Scale the image with a value between 10 and 400. If left blank 100 will be used.

CopyRange

The address of the range to copy.

ScalePercent

Scale the image with a value between 10 and 400. If left blank 100 will be used.

ImageFormat

The format of the image file (If left blank Bmp will be used.): Bmp Bitmap Emf Enhanced metafile Exif Exchangeable Image File Gif Graphics Interchange Format Icon Windows icon Jpeg Joint Photographic Experts Group Png W3C Portable Network Graphics Tiff Tagged Image File Format Wmf Windows metafile

ImageFilename

Specify the name of the file image file.

Folder

Specify the full path to the folder to put the file in. If left blank the Desktop folder will be used.

IncrementFilename

Whether to add a subscript, such as (2), to the filename if the specified file already exists. If not set to TRUE, an existing file with the same name will be overwritten.

UseDialog

Whether to show the Save File dialog to allow the user to select the folder and filename.

DialogResultPropertyName

The name of the script property to hold the FileDialog form result.

FullFilePathPropertyName

The full path of the file that is saved.

FromFile

Copy a specified worksheet from an Excel file into the current view.

General

Copy a worksheet.

Filename

Specify the name of the file to copy from.

Folder

Specify the full path to the folder that contains the file.

ValuesOnly

Whether to replace cell formulas with cell values. If left blank FALSE will be used.

SheetName

Specify the name of the sheet to copy.

NewSheetName

The name of the new sheet.

ToPositionPolicy

Select how to specify where to copy the worksheet to. If left blank "Last" will be used.

ToPosition

If ToPositionPolicy is ToPositionOfSheetNamed then enter a sheet name. If ToPositionPolicy is ToPositionNumber then enter a number.

Password

The password assigned to the saved workbook.

FromWorkbook

The name of the workbook to copy the sheet from. Leave blank to copy from current workbook.

SpecifyFromBy

Select how to specify which worksheet to copy. If left blank SheetNumber will be used.

FromSheetSpec

Specify the sheet-name or sheet-number, depending on SpecifyFromBy.

SpecifyToPosition

Select how to specify where to copy the worksheet to. If left blank "Last" will be used.

ToPosition

If ToPositionPolicy is ToPositionOfSheetNamed then enter a sheet name. If ToPositionPolicy is ToPositionNumber then enter a number.

NewSheetName

The name of the new sheet.

General

Delete a specified binary artifact or binary artifact version.

BinaryArtifactID

The ID of the binary artifact to delete.

DeletionPolicy

Specifies whether to delete all versions, the latest version, or a specific version of the binary artifact specified by the SpecificVersion argument.

SpecificVersion

The version of the binary artifact to delete when the DeletionPolicy argument is set to SpecificVersion.

All

Deletes all page breaks from the sheet.

General

Deletes a page break or breaks from the sheet.

DeleteBreakAddress

The address used to identify the address the break or breaks are deleted from.

General

Deletes rows from a DataTableRange's sheet range.

RowsAddress

The address used to identify the rows within a DataTableRange's sheet range that are deleted. For example, the address of the selected range can be used to delete a DataTableRange's rows.

General

Deletes a specified file.

Filename

Specify the name of the file to delete.

Folder

Specify the folder from which to delete the file. Defaults to the user home directory if left blank.

General

Delete cells.

DeleteRange

The address of the cells to delete.

ShiftDirection

The shift mode for the delete. Warning: ShiftEntireRow and ShiftEntireColumn do not work correctly. Use ShiftEntireRowExcel and ShiftEntireColumnExcel to get the correct result. ShiftEntireColumn performs the same as ShiftLeft (incorrect). ShiftEntireRow performs the same as ShiftUp (incorrect).

Using ShiftLeft will move the cells to the right of any cells in the specified range to the left. Using ShiftUp will move the cells below of any cells in the specified range up. Using ShiftEntireColumnExcel will delete the entire column of any cells in the sprecified range. Using ShiftEntireRowExcel will delete the entire row of any cells in the sprecified range.

VisibleOnly

Set this to TRUE to prohibit deleting hidden rows or columns. The default is FALSE.

General

Execute a workbook script procedure.

ToolAction

Use to execute a workbook script procedure for a specific tool. Use this overload in conjunction with the ToolClicked and/or ToolValueChanged eventlinks.

Procedure

The name of the procedure to execute.

Break

Use this argument to conditionally exit this procedure. This argument will be evaluated only after calling the specified procedure.

Procedure

The name of the procedure to execute.

ToolKey

The key of the tool that the execution of the procedure depends on. If left blank the specified procedure will run for any tool.

Break

Use this argument to conditionally exit this procedure. This argument will be evaluated only after calling the specified procedure.

General

Exit the procedure if the MethodCondition evaluates to TRUE. If run CellByCell then a CellCondition of TRUE in any cell will exit the procedure.

Exit

Determines whether the current procedure is exited.

General

Export the view to an Excel file. The exported file retains the point-of-view, which is used to restore the selected items when the file is imported, using the Import View from Excel tool. For an Essbase Excel view, the cell values within defined send ranges (i.e. Ess.Send.Range.x) are also restored when the file is imported.

Filename

Specify the name of the Excel file. When UseDialog is TRUE, the file name is used as the default file name presented in the Save File dialog. When UseDialog is FALSE, the file name is used as the exported Excel file name.

Folder

Specify the folder to save the Excel file to. When UseDialog is TRUE, the folder is used as the default folder presented in the Save File dialog. When UseDialog is FALSE, the folder is used as the location of the exported Excel file.

IncrementFilename

Whether to add a subscript, such as (2), to the filename if the specified file already exists. If not set to TRUE, an existing file with the same name will be overwritten. This argument is only applicable when UseDialog is FALSE.

UseDialog

Whether to show the Save File dialog to allow the user to select the folder and filename.

DialogResultPropertyName

The name of the script property to hold the FileDialog form result.

FullFilePathPropertyName

The full path of the file that is saved.

Password

Each protected worksheet is password protected with the specified value in order to prevent a user from unprotecting the worksheet in the exported Excel file. If no password is specified, the view's ExportToExcelProtectedWorksheetPassword is used as the password.

AboveAverage

Select the items that are above the average in the specified column.

BeginsWith

Select the items that begin with the specified value from the filter of the specified column.

BelowAverage

Select the items that are below the average in the specified column.

Between

Select the items that lie between two values (inclusive) from the filter of the specified column.

BottomX

Select the bottom X items from the filter of the specified column, where X is a specified number value.

BottomXPercent

Select the bottom X percent items from the filter of the specified column, where X is a specified percent value.

Clear

Clear all selections from all filters on the sheet.

Contains

Select the items that contain the specified value from the filter of the specified column.

DoesNotBeginWith

Select the items that do not begin with the specified value from the filter of the specified column.

DoesNotContain

Select the items that do not contain the specified value from the filter of the specified column.

DoesNotEndWith

Select the items that do not end with the specified value from the filter of the specified column.

DoesNotEqual

Select all values except for specified value.

EndsWith

Select the items that end with the specified value from the filter of the specified column.

Equals

Select one specific value from the filter of the specified column.

FiltersOff

Turn off filtering for the specified range.

FiltersOn

Turn on filtering for the specified range. Functions as a toggle if filters are already on.

GreaterThan

Select the items that are greater than the specified value from the filter of the specified column.

GreaterThanOrEqual

Select the items that are greater than or equal to the specified value from the filter of the specified column.

InList

Select a list of values from the filter of the specified column.

LessThan

Select the items that are less than the specified value from the filter of the specified column.

LessThanOrEqual

Select the items that are less than or equal to the specified value from the filter of the specified column.

NotInList

Select the values from the filter that are not in the specified list.

TopX

Select the top X items from the filter of the specified column, where X is a specified number value.

TopXPercent

Select the top X percent items from the filter of the specified column, where X is a specified percent value.

ColumnNumber

The column number of the filter.

ClearFirst

Whether to clear other selections from the filter before applying the selection.

ShowDropdown

Wheter the filter's dropdown should be displayed after applying the selection.

ColumnNumber

The column number of the filter.

Value

The value to select.

ClearFirst

Whether to clear other selections from the filter before applying the selection.

ShowDropdown

Wheter the filter's dropdown should be displayed after applying the selection.

ColumnNumber

The column number of the filter.

ClearFirst

Whether to clear other selections from the filter before applying the selection.

ShowDropdown

Wheter the filter's dropdown should be displayed after applying the selection.

ColumnNumber

The column number of the filter.

LowValue

The lower value to use in the between range.

HighValue

The higher value to use in the between range.

ClearFirst

Whether to clear other selections from the filter before applying the selection.

ShowDropdown

Wheter the filter's dropdown should be displayed after applying the selection.

ColumnNumber

The column number of the filter.

ValueOfX

The value to use in Top and Bottom filters.

ClearFirst

Whether to clear other selections from the filter before applying the selection.

ShowDropdown

Wheter the filter's dropdown should be displayed after applying the selection.

ColumnNumber

The column number of the filter.

ValueOfX

The value to use in Top and Bottom filters.

ClearFirst

Whether to clear other selections from the filter before applying the selection.

ShowDropdown

Wheter the filter's dropdown should be displayed after applying the selection.

ShowDropdown

Wheter the filter's dropdown should be displayed after applying the selection.

ColumnNumber

The column number of the filter.

Value

The value to select.

ClearFirst

Whether to clear other selections from the filter before applying the selection.

ShowDropdown

Wheter the filter's dropdown should be displayed after applying the selection.

ColumnNumber

The column number of the filter.

Value

The value to select.

ClearFirst

Whether to clear other selections from the filter before applying the selection.

ShowDropdown

Wheter the filter's dropdown should be displayed after applying the selection.

ColumnNumber

The column number of the filter.

Value

The value to select.

ClearFirst

Whether to clear other selections from the filter before applying the selection.

ShowDropdown

Wheter the filter's dropdown should be displayed after applying the selection.

ColumnNumber

The column number of the filter.

Value

The value to select.

ClearFirst

Whether to clear other selections from the filter before applying the selection.

ShowDropdown

Wheter the filter's dropdown should be displayed after applying the selection.

ColumnNumber

The column number of the filter.

Value

The value to select.

ClearFirst

Whether to clear other selections from the filter before applying the selection.

ShowDropdown

Wheter the filter's dropdown should be displayed after applying the selection.

ColumnNumber

The column number of the filter.

Value

The value to select.

ClearFirst

Whether to clear other selections from the filter before applying the selection.

ShowDropdown

Wheter the filter's dropdown should be displayed after applying the selection.

ColumnNumber

The column number of the filter.

Value

The value to select.

ClearFirst

Whether to clear other selections from the filter before applying the selection.

ShowDropdown

Wheter the filter's dropdown should be displayed after applying the selection.

ColumnNumber

The column number of the filter.

Value

The value to select.

ClearFirst

Whether to clear other selections from the filter before applying the selection.

ShowDropdown

Wheter the filter's dropdown should be displayed after applying the selection.

ColumnNumber

The column number of the filter.

Value

The value to select.

ClearFirst

Whether to clear other selections from the filter before applying the selection.

ShowDropdown

Wheter the filter's dropdown should be displayed after applying the selection.

ColumnNumber

The column number of the filter.

List

The list of values to select in the specified column.

Delimiter

The delimiter to use to parse the list of values. Comma, ",", is the default.

ClearFirst

Whether to clear other selections from the filter before applying the selection.

ShowDropdown

Wheter the filter's dropdown should be displayed after applying the selection.

ColumnNumber

The column number of the filter.

Value

The value to select.

ClearFirst

Whether to clear other selections from the filter before applying the selection.

ShowDropdown

Wheter the filter's dropdown should be displayed after applying the selection.

ColumnNumber

The column number of the filter.

Value

The value to select.

ClearFirst

Whether to clear other selections from the filter before applying the selection.

ShowDropdown

Wheter the filter's dropdown should be displayed after applying the selection.

ColumnNumber

The column number of the filter.

List

The list of values to select in the specified column.

Delimiter

The delimiter to use to parse the list of values. Comma, ",", is the default.

ClearFirst

Whether to clear other selections from the filter before applying the selection.

ShowDropdown

Wheter the filter's dropdown should be displayed after applying the selection.

ColumnNumber

The column number of the filter.

ValueOfX

The value to use in Top and Bottom filters.

ClearFirst

Whether to clear other selections from the filter before applying the selection.

ShowDropdown

Wheter the filter's dropdown should be displayed after applying the selection.

ColumnNumber

The column number of the filter.

ValueOfX

The value to use in Top and Bottom filters.

ClearFirst

Whether to clear other selections from the filter before applying the selection.

ShowDropdown

Wheter the filter's dropdown should be displayed after applying the selection.

DataCache

Execute a Procedure for each row in a DataCache.

FileInFolder

Execute a Procedure for each file in a specified folder.

NumberToNumber

Execute a Procedure for each number of a specified range.

SqlDataCache

Execute a Procedure for each row in a DataCache created using AddDataCache.SQLPassthroughDataSet.

A workbook script property with the name of the column will be added for each column of the SqlDataCache as each row of the SqlDataCache is processed by the ForEach method.

If PropertyNamePrefix argument is specified then the name of each property added will be prepended with the PropertyNamePrefix like [PropertyNamePrefix][ColumnName].

The @PVal(<PropertyName>) function can be used within the specified Procedure to get the current value of this property.

DataCacheName

The name of the data-cache that contains the values.

SortOrder

Specifies one or more columns of the DataCache to sort by.

Example: Col1 Example: Col1, Col3 Example: "Col2 DESC, Col1 ASC"

Procedure

The name of the procedure to execute.

ExitLoopCondition

Condition evaluated before each iteration of the ForEach loop. If the condition evaluates to True, the loop is exited.

ColumnNumber

The column number to get each value from. Use ColumnNumber in conjunction with PropertyName to produce a property with the value of the specified column number with each iteration of the ForEach.

PropertyName

If PropertyName is specified, a script property will be added with the value specified by the ColumnNumber argument on each iteration of the ForEach loop with the specified name.

The @PVal(<PropertyName>) function can be used within the specified Procedure to get the current value of this property.

Folder

The full path of the folder to iterate through.

SubFolders

Whether to iterate through the specified folder's subfolders. If left blank FALSE will be used.

FileMatchPattern

Wild-carded file name like *.xlsx. If left blank all files will be processed.

UseDialog

Whether to prompt the user to select a folder. If left blank FALSE will be used.

Procedure

The name of the procedure to execute.

DialogResultPropertyName

If specified a script property with the specified name will be created with result of the file dialog. The @PVal(<property-name>) function can be used to get the value.

ExitLoopCondition

Condition evaluated before each iteration of the ForEach loop. If the condition evaluates to True, the loop is exited.

FileNamePropertyName

If FileNamePropertyName is specified a workbook script property with the specified name will be added with the value of the current file's name. The @PVal(<PropertyName>) function can be used within the specified Procedure to get the current value of this property.

FilePathPropertyName

If FilePathPropertyName is specified a workbook script property with the specified name will be added with the value of the current file's full path. The @PVal(<PropertyName>) function can be used within the specified Procedure to get the current value of this property.

FolderPropertyName

If FolderPropertyName is specified a workbook script property with the specified name will be added with the value of the current file's folder path. The @PVal(<PropertyName>) function can be used within the specified Procedure to get the current value of this property.

StartNumber

The number to begin the ForEach with.

EndNumber

The number to end the ForEach on.

Procedure

The name of the procedure to execute.

ExitLoopCondition

Condition evaluated before each iteration of the ForEach loop. If the condition evaluates to True, the loop is exited.

PropertyName

If PropertyName is specified, a script property will be added with the value specified by the ColumnNumber argument on each iteration of the ForEach loop with the specified name.

The @PVal(<PropertyName>) function can be used within the specified Procedure to get the current value of this property.

DataCacheName

The name of the data-cache that contains the values.

SortOrder

Specifies one or more columns of the DataCache to sort by.

Example: Col1 Example: Col1, Col3 Example: "Col2 DESC, Col1 ASC"

Procedure

The name of the procedure to execute.

ExitLoopCondition

Condition evaluated before each iteration of the ForEach loop. If the condition evaluates to True, the loop is exited.

PropertyNamePrefix

If PropertyNamePrefix is specified the name of each workbook script property will be prepended with the prefix like [PropertyNamePrefix][ColumnName].

The @PVal(<PropertyName>) function can be used within the specified Procedure to get the current value of this property.

Dynamic

Insert page breaks at the specified page height.

General

Insert a single page break.

FlagColumn

(Optional) The column that contains a TRUE/FALSE flag that represents whether a particular row is a candidate for a page break.

PageHeight

The page height in pixels where the break is inserted.

InsertAddress

The address to insert the range at.

General

Insert cells.

InsertAddress

The address to insert the range at.

ShiftDirection

The shift mode for the insert. Warning: ShiftEntireRow and ShiftEntireColumn do not work correctly. Use ShiftEntireRowExcel and ShiftEntireColumnExcel to get the correct result. ShiftEntireColumn performs the same as ShiftRight (incorrect). ShiftEntireRow performs the same as ShiftDown (incorrect).

Using ShiftRight will move the cells to the right of any cells in the specified range to the right. Using ShiftDown will move the cells below of any cells in the specified range down. Using ShiftEntireColumnExcel will insert the entire column of any cells in the sprecified range. Using ShiftEntireRowExcel will insert the entire row of any cells in the sprecified range.

General

Load an Excel Binary Artifact.

ExcelArtifactIDandVersion

The ID and version of the ExcelBinaryArtifact to load.

Password

If the workbook is password-protected, specifies the password assigned to the workbook. NOTE: The password is currently only supported for XLS files that are saved from Excel 2010.

General

Move a worksheet.

SpecifyToPosition

Select how to specify where to move the worksheet to.

ToPosition

If SpecifyToPosition is ToPositionOfSheetNamed then enter a sheet name. If SpecifyToPosition is ToPositionNumber then enter a number.

General

Open a specified binary artifact, using the default editor on the system.

BinaryArtifactID

The ID of the Binary Artifact to open.

VersionPolicy

Specifies whether to open the latest version of the Binary Artifact or a specific version specified by the SpecificVersion argument.

SpecificVersion

The version of the Binary Artifact to open when using the VersionPolicy argument is set to Specific.

General

Open a specified view, and optionally build and/or close the view.

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.

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.

ShareSelectorTokens

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.

ShowViewAsActiveWindow

Whether the opened view's window becomes the active window. By default, the view's window is activated.

ErrorPropertyName

(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.

ClosePolicy

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.

Close

Closes PowerPoint.

CloseFile

Closes a specified file or all files depending on whether a file is specified.

CopyRange

Copy a worksheet range to a PowerPoint slide as an image.

NewFile

Opens a new PowerPoint file for subsequent PowerPoint operations.

OpenFile

Opens an existing PowerPoint file for subsequent PowerPoint operations.

RemoveImage

Remove an image from a PowerPoint slide.

RemoveSlide

Remove an slide from a PowerPoint presentation.

ReplaceImage

Replace an image on a PowerPoint slide with a worksheet range.

SaveFile

Saves one or all PowerPoint files depending on whether a file is specified.

Save

Whether to save the file. Defaults to TRUE.

FullFilePath

The full path to the PowerPoint file. The default is the last file PowerPointOperations interacted with.

Save

Whether to save the file. Defaults to TRUE.

FullFilePath

The full path to the PowerPoint file. The default is the last file PowerPointOperations interacted with.

Range

Specifies the range to copy. Defaults to the sheet's used range.

ReplacePolicy

Whether to replace an image that has the same name. If ReplacePolicy is not specified PerSlideName will be used. None - The image will be added to the specified slide, if any. Otherwise the image will be added to a new slide. OnAnySlide - Every image with the same name on any slide (if any) would be replaced. If an image with the same name does not exist then the image would be added. PerSlideName - If an image with the specified name exists on the specified slide it would be replaced, otherwise it would be added.

SizePolicy

The size of the new image. The default is NewImage. NewImage - The size of the replacing image will be based on the size of the copied range. ReplacedImage - The size of the replacing image will be based on the size of the replaced image.

ImageName

The name of the image. ImageName can be left blank.

SlideName

The name of the slide.

Slide names can be listed in PowerPoint VBA using:

Public Sub ListSlideNames() Dim oSlide As Slide For Each oSlide In Presentations(1).Slides Debug.Print "Slide " & oSlide.SlideIndex & ": " & oSlide.Name Next End Sub

SlideNumber

The number of the slide.

Left

The horizontal position of the image on the slide. Left can be left blank.

Top

The vertical position of the image on the slide. Top can be left blank.

Height

The height of the image in pixels. If Height is specified it overrides other arguments that impact the height of the image. The height of the image is always limited by the height of the slide.

Width

The width of the image in pixels. If Width is specified it overrides other arguments that impact the width of the image. The width of the image is always limited by the width of the slide.

ScalePercent

Scale the image with a value between 10 and 400. The default is 100.

Save

Whether to save the file. Defaults to TRUE.

ImageNamePropertyName

The resolved name of the image.

SlideNamePropertyName

The resolved name of the slide.

Visible

Whether PowerPoint is made visible. Defaults to FALSE.

Filename

Specify the name of the PowerPoint file. When UseDialog is TRUE, the file name is used as the default file name presented in the file dialog. When UseDialog is FALSE, the file name is used as the exported PowerPoint file name.

Folder

Specify the folder to save the PowerPoint file to. When UseDialog is TRUE, the folder is used as the default folder presented in the file dialog. When UseDialog is FALSE, the folder is used as the location of the exported PowerPoint file.

IncrementFilename

Whether to add a subscript, such as (1), to the filename if the specified file already exists. If IncrementFilename is blank an existing file with the same name will be overwritten.

UseDialog

Whether to show the file dialog to allow the user to select the folder and filename.

DialogResultPropertyName

The name of the script property to hold the FileDialog form result. Possible values are OK, Cancel, and Abort.

FullFilePathPropertyName

The full path of the file that is saved.

Visible

Whether PowerPoint is made visible. Defaults to FALSE.

BinaryArtifactID

Specifies a BinaryArtifactID of a PowerPoint binary artifact. If a BinaryArtifactID is specified then file related arguments will be ignored.

Filename

Specify the name of the PowerPoint file. When UseDialog is TRUE, the file name is used as the default file name presented in the file dialog. When UseDialog is FALSE, the file name is used as the exported PowerPoint file name.

Folder

Specify the folder to save the PowerPoint file to. When UseDialog is TRUE, the folder is used as the default folder presented in the file dialog. When UseDialog is FALSE, the folder is used as the location of the exported PowerPoint file.

UseDialog

Whether to show the file dialog to allow the user to select the folder and filename.

DialogResultPropertyName

The name of the script property to hold the FileDialog form result. Possible values are OK, Cancel, and Abort.

FullFilePathPropertyName

The full path of the file that is saved.

FullFilePath

The full path to the PowerPoint file. The default is the last file PowerPointOperations interacted with.

ImageName

The name of the image. ImageName can be left blank.

SlideName

The name of the slide.

Slide names can be listed in PowerPoint VBA using:

Public Sub ListSlideNames() Dim oSlide As Slide For Each oSlide In Presentations(1).Slides Debug.Print "Slide " & oSlide.SlideIndex & ": " & oSlide.Name Next End Sub

SlideNumber

The number of the slide.

Left

The horizontal position of the image on the slide. Left can be left blank.

Top

The vertical position of the image on the slide. Top can be left blank.

Save

Whether to save the file. Defaults to TRUE.

ImageNamePropertyName

The resolved name of the image.

SlideNamePropertyName

The resolved name of the slide.

FullFilePath

The full path to the PowerPoint file. The default is the last file PowerPointOperations interacted with.

SlideName

The name of the slide.

Slide names can be listed in PowerPoint VBA using:

Public Sub ListSlideNames() Dim oSlide As Slide For Each oSlide In Presentations(1).Slides Debug.Print "Slide " & oSlide.SlideIndex & ": " & oSlide.Name Next End Sub

SlideNumber

The number of the slide.

Save

Whether to save the file. Defaults to TRUE.

SlideNamePropertyName

The resolved name of the slide.

FullFilePath

The full path to the PowerPoint file. The default is the last file PowerPointOperations interacted with.

Range

Specifies the range to copy. Defaults to the sheet's used range.

ImageName

The name of the image. ImageName can be left blank.

SlideName

The name of the slide.

Slide names can be listed in PowerPoint VBA using:

Public Sub ListSlideNames() Dim oSlide As Slide For Each oSlide In Presentations(1).Slides Debug.Print "Slide " & oSlide.SlideIndex & ": " & oSlide.Name Next End Sub

SlideNumber

The number of the slide.

Left

The horizontal position of the image on the slide. Left can be left blank.

Top

The vertical position of the image on the slide. Top can be left blank.

Height

The height of the image in pixels. If Height is specified it overrides other arguments that impact the height of the image. The height of the image is always limited by the height of the slide.

Width

The width of the image in pixels. If Width is specified it overrides other arguments that impact the width of the image. The width of the image is always limited by the width of the slide.

ScalePercent

Scale the image with a value between 10 and 400. The default is 100.

SizePolicy

The size of the new image. The default is NewImage. NewImage - The size of the replacing image will be based on the size of the copied range. ReplacedImage - The size of the replacing image will be based on the size of the replaced image.

Save

Whether to save the file. Defaults to TRUE.

ImageNamePropertyName

The resolved name of the image.

SlideNamePropertyName

The resolved name of the slide.

FullFilePath

The full path to the PowerPoint file. The default is the last file PowerPointOperations interacted with.

SaveAsFilePath

Specify the name to save the PowerPoint file as. If a full path is not specified the file will be saved in the original folder.

IncrementFilename

Whether to add a subscript, such as (1), to the filename if the specified file already exists. If IncrementFilename is blank an existing file with the same name will be overwritten.

UseDialog

Whether to show the file dialog to allow the user to select the folder and filename.

DialogResultPropertyName

The name of the script property to hold the FileDialog form result. Possible values are OK, Cancel, and Abort.

FullFilePathPropertyName

The full path of the file that is saved.

Preview

PrintPreview Selection, Sheet, or Workbook.

Print

Print Selection, Sheet, or Workbook.

PrintToFile

Print Selection, Sheet, or Workbook to a file.

PrintWhat

Specifies what to print.

PrintWhat

Specifies what to print.

ShowDialog

Whether to show the print dialog.

PrintWhat

Specifies what to print.

PrinterName

Specifies the name of the print driver, such as Microsoft XPS Document Writer.

Filename

Specify the name of the file.

FolderOption

Select which option is used to determine the folder to save the file to. If no option is specified, the Folder argument is used.

Folder

Specify the full path of the folder to save the file to. The Folder value is only used when the FolderOption is not specified.

IncrementFilename

Whether to add a subscript to the filename if the specified file already exists. If not true, an existing file with the same name will be overwritten.

General

Prompt the user to select a folder.

Caption

The caption to use for the dialog.

SelectedPath

The folder selected when the dialog is initially shown. If left blank the user's desktop folder will be used.

ShowNewFolderButton

Whether the New Folder button is available to the user. If left blank FALSE will be used.

FolderPathPropertyName

The name of the script property that will receive the selected folder path.

DialogResultPropertyName

The name of the script property that will receive the value of the dialog result: OK or Cancel.

Date

Prompt the user for a date value.

Double

Prompt the user for a double value.

DropDown

Prompt the user with a list of values in a drop-down.

Integer

Prompt the user for an integer value.

String

Prompt the user for a string value.

FormCaption

The caption to use for the form.

FormHeight

The height of the prompt form.

FormWidth

The width of the prompt form.

PromptText

The text to use to prompt the user.

NullText

The text to display in the input box if no value has been entered. The NullText does not become the value of the input.

DefaultValue

The value to use by default.

AllowNull

Whether null/empty is a valid entry.

Min

The minimum value to allow.

Max

The maximum value to allow.

FailedValidationText

The message to display if the value is not valid.

InputValuePropertyName

The name of the script property that will receive the input value.

DialogResultPropertyName

The name of the script property that will receive the value of the dialog result, like Cancel, etc.

FormCaption

The caption to use for the form.

FormHeight

The height of the prompt form.

FormWidth

The width of the prompt form.

PromptText

The text to use to prompt the user.

NullText

The text to display in the input box if no value has been entered. The NullText does not become the value of the input.

DefaultValue

The value to use by default.

AllowNull

Whether null/empty is a valid entry.

Min

The minimum value to allow.

Max

The maximum value to allow.

DecimalPlaces

The maximum number of digits to the right of the decimal to allow.

FailedValidationText

The message to display if the value is not valid.

InputValuePropertyName

The name of the script property that will receive the input value.

DialogResultPropertyName

The name of the script property that will receive the value of the dialog result, like Cancel, etc.

FormCaption

The caption to use for the form.

FormHeight

The height of the prompt form.

FormWidth

The width of the prompt form.

PromptText

The text to use to prompt the user.

NullText

The text to display in the input box if no value has been entered. The NullText does not become the value of the input.

DefaultValue

The value to use by default.

AllowNull

Whether null/empty is a valid entry.

MaxCharacters

The maximum number of characters to allow.

DropDownList

The list of values for the drop-down. If the list only contains display-values, separate each value with a semicolon. If the drop-down has display-values and data-values then the display-values should be separated from the data-values with a semicolon, and each row of the list should be followed by a new-line.

HasDataValues

Determines whether the combo-list has display-values and data-values, or just display-values.

LimitToList

Whether the entry must be in the drop-down list.

MaxDropDownItems

The number of rows to show in the drop-down list. The default is 15.

SortStyle

Whether null/empty is a valid entry.

FailedValidationText

The message to display if the value is not valid.

InputValuePropertyName

The name of the script property that will receive the input value.

DialogResultPropertyName

The name of the script property that will receive the value of the dialog result, like Cancel, etc.

FormCaption

The caption to use for the form.

FormHeight

The height of the prompt form.

FormWidth

The width of the prompt form.

PromptText

The text to use to prompt the user.

NullText

The text to display in the input box if no value has been entered. The NullText does not become the value of the input.

DefaultValue

The value to use by default.

AllowNull

Whether null/empty is a valid entry.

Min

The minimum value to allow.

Max

The maximum value to allow.

FailedValidationText

The message to display if the value is not valid.

InputValuePropertyName

The name of the script property that will receive the input value.

DialogResultPropertyName

The name of the script property that will receive the value of the dialog result, like Cancel, etc.

FormCaption

The caption to use for the form.

FormHeight

The height of the prompt form.

FormWidth

The width of the prompt form.

PromptText

The text to use to prompt the user.

NullText

The text to display in the input box if no value has been entered. The NullText does not become the value of the input.

DefaultValue

The value to use by default.

AllowNull

Whether null/empty is a valid entry.

MaxCharacters

The maximum number of characters to allow.

MultiLine

Whether to allow more than one line in the input.

WordWrap

Whether to automatically wrap text.

ScrollBars

The scrollbar configuration for the text box.

PasswordMaskCharacter

A character to use for password masking.

FailedValidationText

The message to display if the value is not valid.

InputValuePropertyName

The name of the script property that will receive the input value.

DialogResultPropertyName

The name of the script property that will receive the value of the dialog result, like Cancel, etc.

General

Refresh the view.

Workbook

Remove a defined name from the workbook.

Worksheet

Remove a defined name from one or all worksheets.

DefinedName

The name to remove.

DefinedName

The name to remove.

Columns

Remove duplicate columns based on values in specified rows.

Rows

Remove duplicate rows based on values in specified columns.

Range

The name or address of the range to remove duplicates from.

HasHeaders

Set this to TRUE if the range has headers that should be ignored. The default is FALSE.

CompareRows

A comma delimited list of row numbers within the specified Range to use for the comparison. Example: 3, 4, 7

ShiftColumns

Whether to shift cells left when removing columns or remove the entire column. The default is "Left".

Range

The name or address of the range to remove duplicates from.

HasHeaders

Set this to TRUE if the range has headers that should be ignored. The default is FALSE.

CompareColumns

A comma delimited list of column numbers within the specified Range to use for the comparison. Example: 3, 4, 7

ShiftRows

Whether to shift cells up when removing rows or remove the entire row. The default is "Up".

General

Remove a workbook script property from the script.

PropertyName

The name of the property to remove.

Any

Remove the specified token from the Application tokens, View tokens, and the view's volatile tokens.

Application

Remove the specified token from the Application tokens.

General

Remove the specified token from the view's volatile tokens.

RemoveAll

Remove all tokens from the specified token tables.

View

Remove the specified token from the View's tokens.

TokenName

The name of the token to remove.

TokenName

The name of the token to remove.

TokenName

The name of the token to remove.

All

Enter TRUE to remove all tokens from all token tables. Selector tokens are not removed.

Application

Enter TRUE to remove all tokens from the application token table.

View

Enter TRUE to remove all view tokens from the view's token table.

TargetView

Enter TRUE to remove all tokens from the targetview's token table. This only applies when the event is OpenViewForMemberCells or OpenViewForDataCells.

TokenName

The name of the token to remove.

General

Remove a worksheet.

SpecifySheetToRemoveBy

Select how to specify which worksheet to remove.

SheetToRemove

Specify the sheet-name or sheet-number of the sheet to remove, depending on SpecifySheetToRemoveBy.

General

Renames a workbook.

SpecifyWorkbookBy

Select how to specify the workbook to rename.

Workbook

Specify the name or number of the workbook to rename, depending on SpecifyWorkbookBy.

NewWorkbookName

The new name of the workbook.

General

Rename one or all worksheets.

SpecifySheetToRenameBy

Select how to specify which worksheet to rename.

SheetToRename

Specify the sheet-name or sheet-number of the sheet to rename, depending on SpecifySheetToRenameBy.

NewSheetName

The new name of the sheet.

General

Repaints the grid control.

Repaint

Determines whether to do the repaint.

General

Find and replace string.

FindWhat

The string that is going to be found and replaced.

ReplaceWith

The string that is going to replace the FindWhat string.

SearchOrder

Whether to replace by columns or rows. Defaults to ByRows if not entered.

MatchCase

Wether to consider Upper/Lower case to determine a match. Defaults to FALSE if not entered.

MatchEntireCellContents

Wether to use the entire cell contents to determine a match. Defaults to FALSE if not entered.

General

Do token replacement.

DeleteBlobs

Deletes one or more documents from a relational database, optionally using a specified filename.

InsertBlobFromFile

Inserts a document from disk into a relational database.

InsertBlobsFromFolder

Inserts one or more documents from disk into a relational database.

SelectBlobToFile

Selects a document from a relational database and saves it to disk.

SelectBlobsToFolder

Select one or more documents from a relational database and saves them to disk.

UpdateBlobFromFile

Updates a relational database blob with a document from disk.

UpdateBlobsFromFolder

Updates relational database blobs with one or more documents from disk.

SQLConnectionID

The SQL connection ID used by the operation. The specified SQL Connection must have the Database (type) property set in order to generate insert/update parameter values.

SQLPassthroughDataSetID

The SQLPassthroughDataSet used to select/insert/update/delete a blob from the relational database.

DeleteSQL

The SQL statement used to delete a blob from the relational database.

FilenameColumn

The name of the relational table column that contains the filename associated with the BLOB data.

LocalFilePath

The full path of the local file to be saved or uploaded.

UseDialog

(Optional) Whether to display a file dialog that allows the user to choose the local file to be uploaded or saved. If left blank, FALSE will be used.

DialogFilter

(Optional) A filter string that determines which choices that appear in the save and open file dialogs. The following is an example of a filter string: "PDF files (*.pdf)|*.pdf|All files (*.*)|*.*"

DialogTitle