Returns information about individual Essbase spreadsheet options.
EssVGetSheetOption(sheetName, item) ByVal sheetName As Variant ByVal item As Variant
Text name of worksheet to operate on. sheetName is of the form "[Book.xls]Sheet". If sheetName is Null or Empty, the active worksheet is used.
Number indicating which option is to be retrieved. item cannot be Null or Empty. Table 10 indicates which options are returned for which number.
Table 10. Item Number Options, Return Types, and Values
Returns the value of the current setting as a string, number, or Boolean. If an error occurs, #VALUE! is returned. When item is out of range, #NUM! is returned.
Declare Function EssVGetSheetOption Lib "ESSEXCLN.XLL" (ByVal sheetName As Variant, ByVal item As Variant) As Variant Sub GetSheet() Dim X As String X=EssVGetSheetOption("Sheet1", 6) If X="#NUM!" Then MsgBox("Invalid item ID specified.") Else If X="#VALUE!" Then MsgBox("Error. Option could not be found.") Else MsgBox("Suppress Missing is set to " + X) End If End If End Sub