HypDisplayToLinkView

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

Description

HypDisplayToLinkView() displays Office documents to Word or PowerPoint; or displays a grid to Excel.

Note:

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

Note:

This function is used specifically with dynamic link views, as described in Dynamic Link Views

Syntax

HypDisplayToLinkView (vtDocumentType, vtDocumentPath)

ByVal vtDocumentType As Variant

vtDocumentPath As Variant

Parameters

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

  • EXCEL_APP

  • WORD_APP

  • PPOINT_APP

vtDocumentPath: The path to the document. Required only in case of WORD_APP or PPOINT_APP.

Return Value

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

Examples

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

Sub Macro()
  Dim vtGrid as Variant
  Sts = HypConnect(Empty, "system", "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