EssCalculate

Description

Initiates a calculation on the server.

Syntax

EssCalculate([workbookName]sheetName, calcScript, synchronous)

Where [workbookName]sheetName is the text name of the workbook and worksheet from which the connection information is used.

calcScript is the text name of the calculation object to calculate. This object must exist on the server.

synchronous is a logical value that determines whether the calculation is performed synchronously or asynchronously. A value of TRUE indicates that the script is run synchronously, FALSE indicates asynchronous processing.

Example

=EssCalculate("[Sample.xls]Sheet1","Default.CSC",FALSE)

Notes:

The active worksheet is used when the sheetName parameter is missing.
The default calculation script is used when the calcScript parameter is missing.
The value TRUE is assumed when the synchronous parameter is missing.