HypDisplayToLinkView

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

Description

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

Note:

The link action is performed with the latest content of the dynamic link query.

Syntax

HypDisplayToLinkView (vtDocumentType, vtDocumentPath)

ByVal vtDocumentType As Variant

ByVal vtDocumentPath As Variant

Parameters

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

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