Data provider types: Oracle Essbase, Oracle Hyperion Planning, Oracle Planning and Budgeting Cloud, Oracle Hyperion Financial Management, Oracle Hyperion Enterprise®
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