HypCopyMetaData
Describes the Oracle Smart View for Office VBA function, HypCopyMetaData.
Cloud data provider types: Oracle Analytics Cloud - Essbase, Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting
On-premises data provider types: Oracle Essbase, Oracle Hyperion Planning, Oracle Hyperion Financial Management
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