HypDisplayToLinkView

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

Description

HypDisplayToLinkView() displays Office documents to Word or PowerPoint or grids to Excel.

Syntax

HypDisplayToLinkView (vtDocumentType, vtDocumentPath)

ByVal vtDocumentType As Variant

ByVal vtDocumentPath As Variant

Parameters

vtDocumentType:The destination for the link view. Valid values:

• EXCEL_APP

• WORD_APP

• PPOINT_APP

vtDocumentPath: The path to the document. Required only for WORD_APP or PPOINT_APP.

Return Value

Returns 0 if successful; otherwise, returns the appropriate error code.

Example

Declare Function HypDisplayToLinkView Lib "HsAddin" (ByVal vtDocumentType As Variant, ByVal vtDocumentPath As Variant) As Long

Sub Example_HypDisplayToLinkView()
  Dim vtGrid As Variant
  Sts = HypConnect(Empty, "UserName", "Password", "MyDemoBasic")
  Sts = HypRetrieve(Empty)
  Range("B2").Select
  Sts = HypGetSourceGrid(Empty, vtGrid)
  Sts = HypSetColItems(1, "Market", "East", "West", "South", "Central", "Market")
  Sts = HypDisplayToLinkView("EXCEL_APP", "")
End Sub