HypDisplayToLinkView

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

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

Data provider types:

Note:

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

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