HypCopyMetaData

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

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

Description

HypCopyMetaData() copies the metadata from one worksheet to another worksheet.

Syntax

HypCopyMetaData (vtSourceSheetName, vtDestinationSheetName)

ByVal vtSourceSheetName As Variant

ByVal vtDestinationSheetName As Variant

Parameters

vtSourceSheetName: The name of the worksheet that contains the data to be copied

vtDestinationSheetName: The name of the destination worksheet

Return Value

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

Example

Public Declare Function HypCopyMetaData Lib "HsAddin" (ByVal vtSourceSheetName As Variant, ByVal vtDestinationSheetName As Variant) As Long
Sub Example_HypCopyMetaData()
Dim LRet As Long
LRet = HypCopyMetaData ("Sheet1", "Sheet2")
End Sub