Data provider types: Essbase, Planning, Financial Management, Hyperion Enterprise
HypCopyMetaData() copies the metadata from one worksheet to another worksheet.
HypCopyMetaData (vtSourceSheetName, vtDestinationSheetName)
ByVal vtSourceSheetName As Variant
ByVal vtDestinationSheetName As Variant
vtSourceSheetName: The name of the worksheet that contains the data to be copied
vtDestinationSheetName: The name of the destination worksheet
Returns 0 if successful; otherwise, the appropriate error code.
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