HypIsSmartViewContentPresent

Data source types: Essbase, Planning, Financial Management, Hyperion Enterprise

Description

HypIsSmartViewContentPresent() checks to see whether the sheet contains Smart View content.

Syntax

HypIsSmartViewContentPresent(vtSheetName [in], pContentType [out])

ByVal vtSheetName As Variant

ByRef vtTypeOfContentsInSheet

Parameters

vtSheetName: For future use. Currently the active sheet is used.

pContentType: Function returns appropriate type of content on the sheet. Possible values are in the enum as defined below.

Enum TYPE_OF_CONTENTS_IN_SHEET
    EMPTY_SHEET
    ADHOC_SHEET
    FORM_SHEET
    INTERACTIVE_REPORT_SHEET
End Enum

Return Value

VARIANT_TRUE if the worksheet contains Smart View content, otherwise VARIANT_FALSE.

Example

Public Declare Function HypIsSmartViewContentPresent Lib "HsAddin" (ByVal vtSheetName As Variant, _
ByRef vtTypeOfContentsInSheet As TYPE_OF_CONTENTS_IN_SHEET) As Boolean

Sub TestIsSVCContentOnSheet()

	Dim oRet As Boolean
	Dim oContentType As TYPE_OF_CONTENTS_IN_SHEET
	Dim oSheetName As String
	Dim oSheetDisp As Worksheet

	oSheetName = Empty
	Set oSheetDisp = Worksheets(Empty)
	oRet = HypIsSmartViewContentPresent (Empty, oContentType)

End Sub