HypIsSmartViewContentPresent

Describes the Oracle Smart View for Office VBA function, HypIsSmartViewContentPresent.

Cloud data provider types: Oracle Essbase, Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting

On-premises data provider types: Oracle Essbase, Oracle Hyperion Planning, Oracle Hyperion Financial Management

Description

HypIsSmartViewContentPresent() determines whether the sheet contains Smart View 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