Data source types: Financial Management (ad hoc only), Hyperion Enterprise (ad hoc only)
HypTranslate() calls the Translate method for Financial Management data sources.
HypTranslate (vtSheetName, vtRange)
ByVal vtSheetName As Variant
By Val vtRange As Variant
vtSheetName: For future use. Currently the active sheet is used.
vtRange: Range object which refers to the data to be used. Passing an empty or null parameter uses the current selection from the sheet.
Returns 0 if successful; otherwise, returns the corresponding error code.
Declare Function HypTranslate Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtRange As Variant) As Long
sts = HypTranslate (Empty, Empty)