CB.GetWorksheetVersion

This function returns the Crystal Ball data version ID or build number for the active or specified worksheet. It has three optional parameters. The first optional parameter, Worksheet, indicates the target worksheet. If omitted, information is returned for the active worksheet. The second optional parameter, VersionType, and the third optional parameter, Index, can return the full or partial version ID or build number as a string.

Note:

For Crystal Ball versions 7.0 through 7.1.2, the version ID returned is "7.0.0". This string changed starting with data created by Crystal Ball version 7.2.

Table 140. CB.GetWorksheetVersion Returned Data Type

Returned Value	Returned Data Type
The Crystal Ball data version ID or build number returned for the active or specified worksheet	Variant

Table 141. CB.GetWorksheetVersion Parameters

Parameter	VBA Data Type	Value	Description
Worksheet (Optional)	Worksheet	A Microsoft Excel object indicating the target workbook and worksheet	Indicates the target worksheet whose version to return. If omitted, returns the version of the currently active worksheet.
VersionType (Optional)	Variant	0 or 1	Returns the Crystal Ball version ID or build number as a string. For details, see Table 139.
Index (Optional)	Integer	An integer from 1 to the number of sections in the string returned by VersionType	Returns the specified portion of the version ID or build number, counting from left to right. For details, see Table 139.