Table 15 lists the Smart View VBA functions alphabetically. A detailed description for each function, including the syntax, parameter, return value, and sample code, follows the table.
Table 15. VBA Functions and Supported Providers
VBA Functions
HypAddLRO
HypCalculate
HypCalculateContribution
HypCell
HypConnect
HypConnected
HypConnectionExists
HypConsolidate
HypConsolidateAll
HypConsolidateAllWithData
HypCopyMetaData
HypCreateConnection
HypDeleteAllLROs
HypDeleteCalc
HypDeleteMetadata
HypDisconnect
HypDisconnectEx
HypExecuteCalcScript
HypExecuteCalcScriptEx
HypExecuteDrillThroughReport
HypExecuteQuery
HypFindMember
HypFindMemberEx
HypForceCalculate
HypForceCalculateContribution
HypForceTranslate
HypFreeDataPoint
HypGetAncestor
HypGetChildren
HypGetCellRangeForMbrCombination
HypGetColCount
HypGetColItems
HypGetConnectionInfo
HypGetDataPoint
HypGetDimMbrsForDataCell
HypGetDrillThroughReports
HypGetGlobalOption
HypGetLinkMacro
HypGetMemberInformation
HypGetNameRangeList
HypGetParent
HypGetPOVCount
HypGetPOVItems
HypGetRowCount
HypGetRowItems
HypGetSharedConnectionsURL
HypGetSheetOption
HypGetSourceGrid
HypGetSubstitutionVariable
HypIsAttribute
HypIsDescendant
HypIsExpense
HypIsFreeForm
HypIsParent
HypIsSmartViewContentPresent
HypIsUDA
HypKeepOnly
HypListCalcScripts
HypListCalcScriptsEx
HypListLROs
HypOtlGetMemberInfo
HypPivot
HypPivotToGrid
HypPivotToPOV
HypPreserveFormatting
HypQueryMembers
HypRedo
HypRemoveConnection
HypRemoveOnly
HypResetFriendlyName
HypRetrieve
HypSetActiveConnection
HypSetAliasTable
HypSetBackgroundPOV
HypSetCellsDirty
HypSetColItems
HypSetConnectionInfo
HypSetGlobalOption
HypSetLinkMacro
HypSetMenu
HypSetOption
HypSetPOV
HypSetPOVItems
HypSetRowItems
HypSetSharedConnectionsURL
HypSetSheetOption
HypShowPOV
HypSubmitData
HypTranslate
HypUndo
HypUpdateLRO
HypUseLinkMacro
HypZoomIn
HypZoomOut