HypIsSmartViewContentPresent

Data provider types: Oracle Essbase, Oracle Hyperion Planning, Oracle Planning and Budgeting Cloud, Oracle Hyperion Financial Management

Description

HypIsSmartViewContentPresent() determines whether the sheet contains Oracle Smart View for Office content.

Syntax

HypIsSmartViewContentPresent(vtSheetName, vtTypeOfContentsInSheet])

ByVal vtSheetName As Variant

ByRef vtTypeOfContentsInSheet

Parameters

vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used.

vtTypeOfContentsInSheet: Output parameter; returns the type of content on the worksheet. Possible values are in the enum as follows;.

Enum TYPE_OF_CONTENTS_IN_SHEET
    EMPTY_SHEET
    ADHOC_SHEET
    FORM_SHEET
    INTERACTIVE_REPORT_SHEET
End Enum

Return Value

Returns True if the worksheet contains Smart View content; otherwise, returns False.

Example

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

Sub Example_HypIsSmartViewContentPresent()
        Dim Ret As Boolean
        Dim vtTypeOfContentsInSheet As TYPE_OF_CONTENTS_IN_SHEET
        Dim SheetName As String
        Dim SheetDisp As Worksheet

        SheetName = Empty
        Set SheetDisp = Worksheets("Sheet1")
        Ret = HypIsSmartViewContentPresent (Empty, ContentType)
End Sub